Making uploaded images square
Make square image
Possible Duplicate:          I have seen  in SQL. I wonder how would you approach the opposite problem: splitting coma delimited string into rows of data:  Lets say I have tables:  userTypedTags(userID,commaSeparatedTags) 'one entry per user tags(tagID,name)   And want to insert data into table  userTag(userID,tagID) 'multiple entries per user   Inspired by  question  EDIT  Thanks for the answers, actually more then one deserves to be accepted but I can only pick one, and the  with recursions seems pretty clean to me. It works on SQL Server 2005 and above.   For earlier version of SQL Server the solution  can be used.  For working with text data type  will be helpful. Thanks again. Reading a 5 Band resistor with Gold as a middle band? Can anyone read the resistor that the arrow is pointing to?  From what I know you can not have a gold band as a number and if I am reading it correctly it has a tolerance of 0 which does not seem right. Is there ever a point you aren't following Harry's perspective? In the Harry Potter books, is there ever a point that is not from the perspective of Harry? There are a few times you are inside Voldemort's mind, but that is really just a an extension of Harry's mind.  Is there ever a point where you are in the perspective or the mind of someone other than Harry (as in hearing their thoughts)? Is it possible to link multiple leaders lines to one piece of annotation?  I'm working in ArcGIS 10.2 Desktop Advanced with non-feature linked geodatabase annotation. I have hundreds of numbers labeling various polygons, but some polygons share a number. Instead of creating multiple numbers/annotations for each polygon I'd like to have one number with multiple lines pointing to each polygon.   So, in the image below, the number 5 corresponds to multiple polygons. Here I've moved 5 from it's ideal location to show that the second leader line is not connected to the number annotation. My workaround has been to create another piece of geodatabase annotation with a blank text string to serve as a placeholder for a leader line. The other option was to use map/graphic annotation to create the second leader line, but with the multiple disadvantages of not being in the same annotation feature class as the number annotation.    My goal would be for each piece of number annotation to be connected to multiple leader lines like appears below. Are there any tools, methods, incantations to recover recently deleted files on Ubuntu?  If it makes any difference, I want to recover a  2.x database file. But would be better to have a method/tool that works on any kind of file. I know that there's a difference between relativistic and rest mass. Relativistic mass is "acquired" when an object is moving at speeds comparable to the speed of light. Rest mass is the inherent mass that something has regardless of the speed its moving at.  When fusion happens, a certain percentage of the rest mass of two hydrogen atoms is converted into energy. I understand that $E = m_{rest}c^2$.   How does the rest mass of an object turn into energy? Does this involve particle physics? Doesn't this suggest that rest mass can be viewed as some sort of potential energy? It seems to me that it's a sort of locked energy that has to undergo a certain process to expel its energy to surrounding particles.  Also, Why does only a small percentage of rest mass turn into energy? Why not all of it. What dictates how much rest mass gets converted into energy? Delete specific line number(s) from a text file using sed? I want to delete one or more specific line numbers from a file. How would I do this using sed? I have several AppExchange apps installed that are failing tests. What is the recommended approach to resolving this? Are tests run when a new package is installed? Is there a way to determine what is actually failing besides the name of the method and something like "expected true, actually false"? The test results rarely show enough information to be useful.   What I'm doing atm, is checking for updates for the packages, and then writing the company with the failing test results.   Any feedback would be appreciated. How can I fix "unbalanced brackets" in my data tag? What is so special about speed of light in vacuum? I will try to be as explanatory as possible with my question. Please also note that I have done my share of googling and I am looking for simple language preferable with some example so that I can get some insight in this subject.  My question is what is so special about $c$? Why only $c$. Its like chicken and egg puzzle for me. Does Einstein reached to $c$ observing light or does he got to light using some number which turned out equal to $c$.   Why is $c$ not relative. If something has zero rest mass like a photon why they only travel at $c$ in vacuum and not with $c+1$ or $c-1$? How can I enable access to USB devices within VirtualBox guests? I cannot see any USB devices within my VirtualBox guest VMs from my host. How do I enable access for my guest VMs?  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Why is document.write considered a "bad practice"? We all know that speed of gravitational waves (GW) and that of light in space are exactly the same (= $c$).  We also know that space is medium for GW.   Does that mean space is also the medium for light?  Because both of them are waves, and speed of a wave is property of the medium.   Is there any other way to justify the identical speed of the two? This is the problem I am currently having trouble with:  If $\lambda_1$ and $\lambda_2$ are eigenvalues of matrix  $$         \begin{bmatrix}         a &amp; b\\         c &amp; d\\         \end{bmatrix}$$prove that $\lambda_1^2$, $\lambda_1\lambda_2$ and $\lambda_2^2$ are eigenvalues of matrix $A$.     $$A=\begin{bmatrix}     a^2 &amp; ab &amp; b^2\\     2ac &amp; ad+bc &amp;2bd\\     c^2 &amp; cd &amp;d^2\\     \end{bmatrix}$$  What have I considered so far:   I tried to find characteristic polynomial of first matrix and then find the roots which would be $\lambda_1$ and $\lambda_2$. I was hoping I can make a connection with characteristic polynomial of matrix $A$, but it got too complicated and did not seem like the right idea. Since there are two eigenvalues for first matrix, there are two eigenvectors. I thought about somehow using $A\vec v_i=\lambda_i\vec v_i$, where $i=1,2$  Also, I thought about finding a connection between these two matrices. What I see is that the sum of elements of first and second column, of first matrix, are $(a+c)$ and $(b+d)$, respectively.  Sum of first, second and third column of matrix $A$ are $(a+c)^2, (a+c)(b+d)$ and $(b+d)^2$. Now, if I could assign $\lambda_1$ and $\lambda_2$ to $(a+c)$ and $(b+d)$, then I would get that sum of first, second and third column of matrix $A$ are $\lambda_1^2$, $\lambda_1\lambda_2$ and $\lambda_2^2$, but what would be next?   I thought it would be good to combine 2. and 3rd idea, but I am not making any progress.  I appreciate any help. '₴' is a currency sign used for the Ukrainian Hryvnia. It's in Unicode since 2004. I want to use it in spreadsheets as a sign for money values, but Google Spreadsheets doesn't understand it as a number if I add it after or before my value in the cell. How do I make Google Spreadsheets understand it's currency and display it as a number in my desired format? short view distance in 3d view? I am trying to change the page size in the QGIS 3.0 Composer but I am not able to see the Composition tab.  I have right clicked an empty space in the toolbar but did not see anything about composition.  I am using Windows 7.  I tried looking at the QGIS docs but they are still in testing. Preventing other users from viewing my files Ref:   My Ubuntu user account name "user-3121" with type as "Administrator". There is one more account named "admin" with type as "Administrator". How can I be sure whether or not "admin" can login as me or otherwise view my files in "user-3121"?  I discussed this with the other user and we have tried to modify /etc/sudoers to protect my files:  Cmnd_Alias   SHELLS = /bin/sh,/bin/bash,/bin/ksh, /usr/bin/x11/passwd  Cmnd_Alias   SU = /usr/bin/su,/bin/su,/usr/bin/gksudo,/usr/bin/sudo,/usr/bin/su bash,/usr/bin/sudo /bin/bash,/usr/sbin/visudo  Cmnd_Alias   PASS = /usr/bin/passwd root,/bin/* * root,/bin/* * sysadmin,/bin/* * /home/sysadmin,/usr/bin/passwd  Cmnd_Alias      EDIT= /bin/* /etc/sudoers,/bin/* sudoers,/bin/* /etc/passwd,/bin/* passwd,/bin/* /etc/group,/bin/* group,/bin/* /etc/shadow,/bin/* shadow,/*/*/[a-z]* /etc/sudoers,/*/*/[a-z]* /etc/passwd,/*/*/[a-z]* /etc/group,/*/*/[a-z]* /etc/shadow,/*/*/[a-z]* sudoers,/*/*/[a-z]* passwd,/*/*/[a-z]* group,/*/*/[a-z]* shadow  Cmnd_Alias   CMDS = /usr/sbin/userdel * sysadmin,/usr/sbin/userdel sysadmin,/usr/sbin/deluser * sysadmin,/usr/sbin/deluser sysadmin  root    ALL=(ALL) ALL, !CMDS  %admin ALL=(ALL) ALL, !SHELLS, !SU, !CMDS, !PASS, !EDIT %sudo  ALL=(ALL) ALL,!SHELLS, !SU, !CMDS, !PASS, !EDIT  admin ALL=(ALL) ALL administrator ALL=(ALL) ALL   If "admin" can still read my data, how do I prevent that?  Also how does this configuration work, it allows "user-3121" to run some sudo commands, but it doesn't actually mention "user-3121" anywhere?  P.S. I'm the only person who knows the password for the "root" user, so that I can log in as root using the "su" command. Reputation and inbox notification shows up again after refresh This was asked before too. .  Currently I am facing the issue of appearance of reputation notification in above toolbar.  I can see the reputation notification, for every page refresh even after clicking and viewing the notification.  current browser: Chrome Version 36.0.1985.143 m The entire  site is blank right now.  The header and footer are shown, but no questions.