Computing desk | ||
---|---|---|
< May 5 | << Apr | May | Jun >> | May 7 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
Hi, I'm currently using the following query
SELECT * FROM `mytable` WHERE mainproperty=`foo` GROUP BY `mainproperty`, `datetime`, `property` ORDER BY `datetime` DESC, `property` ASC
Which returns something like
id;mainproperty;property;value;datetime ; 01; foo; bar1; 1;2010-05-05 01:14:59; 02; foo; bar2; 0;2010-05-05 01:14:59; 03; foo; bar1; 1;2010-05-05 01:04:15; 04; foo; bar2; 0;2010-05-05 01:04:15; 05; foo; bar3; 4;2010-05-05 01:04:15;
What I'd like it to output is:
id;mainproperty;property;value;datetime ; 01; foo; bar1; 1;2010-05-05 01:14:59; 02; foo; bar2; 0;2010-05-05 01:14:59; 05; foo; bar3; 4;2010-05-05 01:04:15;
==> Always show only the newest entry for each property belonging to mainproperty='foo'. (Since there is no property 'bar3' dated '2010-05-05 01:14:59', the one from '2010-05-05 01:04:15' is shown).
What would the proper query string for that look like? -- 78.43.60.58 ( talk) 08:28, 6 May 2010 (UTC)
SELECT * FROM `mytable` A WHERE A.mainproperty=`foo` AND A.datetime = (SELECT MAX(B.datetime) FROM `mytable` B WHERE B.mainproperty=`foo` AND A.property = B.property) GROUP BY A.`mainproperty`, A.`datetime`, A.`property` ORDER BY A.`datetime` DESC, A.`property` ASC
-- Rixxin ( talk) 13:52, 6 May 2010 (UTC)
SELECT * FROM `mytable` A WHERE A.mainproperty=`foo` AND A.datetime = (SELECT MAX(B.datetime) FROM `mytable` B WHERE B.mainproperty=A.mainproperty AND A.property = B.property) GROUP BY A.`mainproperty`, A.`datetime`, A.`property` ORDER BY A.`datetime` DESC, A.`property` ASC
I've been trying to set up a SWF that plays a Flash video (FLV) format, which is usually not a huge problem (I've done it before, I'm not doing anything weird in the FLV conversion). For some reason Flash is occasionally bugging out on me and crashing. In Safari, the Flash applet suddenly goes white and is replaced by an upside down caution sign (like File:Caution sign used on roads pn.svg this but upside down). I then need to reboot Safari before it will even run Flash again. On Firefox it seems to just crash out usually silently (but sometimes with a funny little blurt as the audio skips for a second) — suddenly my video is gone and Firefox won't run any Flash again until reboot either. Both of these are on Mac OS X 10.4.11.
In my Console, I get the following message whenever it happens in FIrefox:
Inconsistent heap state: Failed to abort error: out of memory
Does this just mean that my FLV is too big for my computer, or for Flash, or...? I've never had issues with FLVs being too large before, and Googling the error message didn't come up with very much that was useful. Any thoughts? It seems to happen with large FLVs (e.g. over 100MB in file size), but also when I open smaller FLVs via the browser sequentially with these files (so I open a 10MB FLV and then a 50MB FLV and it crashes, whereas if I had only opened one or the other it would have been fine).
Is this a Flash issue, a hardware issue (I have plenty of RAM free), something wrong with these particular FLVs, or...? Any thoughts? I find it odd since I would expect that if this were something common, YouTube would crash out on me or something like that, not just my own custom Flash player (which is just a pretty standard Flash template). -- Mr.98 ( talk) 13:45, 6 May 2010 (UTC)
I need to backup 900GB from one hard drive to another. I've tried SyncToy and it works, but I was wondering if anyone here had suggestions for other good, preferably free, backup programs? 82.43.89.71 ( talk) 14:54, 6 May 2010 (UTC)
Thanks everyone. I've installed the windows version of rsync but I don't know how to use it. What would be the command to copy all of c:\ to f:\ for example. And I'd like to do a backup every month or so, would it need to copy all the files each time or only the new/changed ones? 82.43.89.71 ( talk) 17:58, 6 May 2010 (UTC)
Is it possible to limit the amount of RAM a specific program on Windows can consume? I realize this might make the program unstable or unusable, but I would like to test limiting RAM on several programs that take too much and make my overall system unusable while they're running. Thanks. 82.43.89.71 ( talk) 18:49, 6 May 2010 (UTC)
Step 2: Select the Processes tab. Check or click on show processes from all users. If you have Windows Vista you may have to allow the UAC Window that appear.
Step 3: Press "Memory" twice. That will order the processes from those using the most memory to the one using the least.
-- Tyw7 ( ☎ Contact me! • Contributions) Changing the world one edit at a time! 13:52, 8 May 2010 (UTC)
At one library I go to there is a relatively new HP mouse. I'm not touching it and as far as I know nothing is moving. I think it uses a red light rather than a ball. The arrow keeps moving all over the place, and it's hard for me to make it stand still in order to click. It will turn stuff blue at the slightest provocation, or fail to turn anything blue when I want it to, when I am copying and pasting or even just clicking to change the URL at the top of the screen. Vchimpanzee · talk · contributions · 19:57, 6 May 2010 (UTC)
They did just replace the mouse. Another one was having a great deal of difficulty doing anything. The pad is kind of rough, so I'll mention that to them. Thanks. Vchimpanzee · talk · contributions · 20:36, 6 May 2010 (UTC)
Hi all, I'm plotting some data on Excel and I'm fitting a least-squares line to it by using the "Add trendline" option on the plot of the data. I need to show where the x-intercept of the line occurs (standard addition curve, so I don't have data that far back) and I can't get excel to predict back that many periods. How can I extend the line back? Thanks for your help. 169.229.76.114 ( talk) 20:12, 6 May 2010 (UTC)
I didn't want to do that just because I didn't want an actual data point way back there, but anyways the whole thing is a moot point now. Thanks for the suggestion, though. 169.229.76.114 ( talk) 20:21, 8 May 2010 (UTC)
Hello! I have a 64-bit system with the 64-bit JRE but I also had to install the 32-bit JRE so I can run applets in Firefox, which is 32-bit. I just want to make sure that I'm using the 64-bit JRE for everything else, mainly when I call java -jar myJar
from the command prompt. java -version
doesn't tell me what architecture. What's the command that will tell me what .exe file java
is associated with? I think Linux has which
to do this, but I'm looking for how to do this with Windows. Thanks!--
el Aprel (
facta-
facienda)
20:32, 6 May 2010 (UTC)
Is it possible to import messages from Live Mail to Outlook Express? I tried Live Mail for a couple of days, and I don't like it, so I'm going back to Outlook Express. It would be handy to be able to import those messages which arrived in the time I was using Live Mail. They are still on the Googlmail server. I tried the Import wizard on Outlook Express, but it didn't give Live Mail as an option to import from. DuncanHill ( talk) 23:17, 6 May 2010 (UTC)
Computing desk | ||
---|---|---|
< May 5 | << Apr | May | Jun >> | May 7 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
Hi, I'm currently using the following query
SELECT * FROM `mytable` WHERE mainproperty=`foo` GROUP BY `mainproperty`, `datetime`, `property` ORDER BY `datetime` DESC, `property` ASC
Which returns something like
id;mainproperty;property;value;datetime ; 01; foo; bar1; 1;2010-05-05 01:14:59; 02; foo; bar2; 0;2010-05-05 01:14:59; 03; foo; bar1; 1;2010-05-05 01:04:15; 04; foo; bar2; 0;2010-05-05 01:04:15; 05; foo; bar3; 4;2010-05-05 01:04:15;
What I'd like it to output is:
id;mainproperty;property;value;datetime ; 01; foo; bar1; 1;2010-05-05 01:14:59; 02; foo; bar2; 0;2010-05-05 01:14:59; 05; foo; bar3; 4;2010-05-05 01:04:15;
==> Always show only the newest entry for each property belonging to mainproperty='foo'. (Since there is no property 'bar3' dated '2010-05-05 01:14:59', the one from '2010-05-05 01:04:15' is shown).
What would the proper query string for that look like? -- 78.43.60.58 ( talk) 08:28, 6 May 2010 (UTC)
SELECT * FROM `mytable` A WHERE A.mainproperty=`foo` AND A.datetime = (SELECT MAX(B.datetime) FROM `mytable` B WHERE B.mainproperty=`foo` AND A.property = B.property) GROUP BY A.`mainproperty`, A.`datetime`, A.`property` ORDER BY A.`datetime` DESC, A.`property` ASC
-- Rixxin ( talk) 13:52, 6 May 2010 (UTC)
SELECT * FROM `mytable` A WHERE A.mainproperty=`foo` AND A.datetime = (SELECT MAX(B.datetime) FROM `mytable` B WHERE B.mainproperty=A.mainproperty AND A.property = B.property) GROUP BY A.`mainproperty`, A.`datetime`, A.`property` ORDER BY A.`datetime` DESC, A.`property` ASC
I've been trying to set up a SWF that plays a Flash video (FLV) format, which is usually not a huge problem (I've done it before, I'm not doing anything weird in the FLV conversion). For some reason Flash is occasionally bugging out on me and crashing. In Safari, the Flash applet suddenly goes white and is replaced by an upside down caution sign (like File:Caution sign used on roads pn.svg this but upside down). I then need to reboot Safari before it will even run Flash again. On Firefox it seems to just crash out usually silently (but sometimes with a funny little blurt as the audio skips for a second) — suddenly my video is gone and Firefox won't run any Flash again until reboot either. Both of these are on Mac OS X 10.4.11.
In my Console, I get the following message whenever it happens in FIrefox:
Inconsistent heap state: Failed to abort error: out of memory
Does this just mean that my FLV is too big for my computer, or for Flash, or...? I've never had issues with FLVs being too large before, and Googling the error message didn't come up with very much that was useful. Any thoughts? It seems to happen with large FLVs (e.g. over 100MB in file size), but also when I open smaller FLVs via the browser sequentially with these files (so I open a 10MB FLV and then a 50MB FLV and it crashes, whereas if I had only opened one or the other it would have been fine).
Is this a Flash issue, a hardware issue (I have plenty of RAM free), something wrong with these particular FLVs, or...? Any thoughts? I find it odd since I would expect that if this were something common, YouTube would crash out on me or something like that, not just my own custom Flash player (which is just a pretty standard Flash template). -- Mr.98 ( talk) 13:45, 6 May 2010 (UTC)
I need to backup 900GB from one hard drive to another. I've tried SyncToy and it works, but I was wondering if anyone here had suggestions for other good, preferably free, backup programs? 82.43.89.71 ( talk) 14:54, 6 May 2010 (UTC)
Thanks everyone. I've installed the windows version of rsync but I don't know how to use it. What would be the command to copy all of c:\ to f:\ for example. And I'd like to do a backup every month or so, would it need to copy all the files each time or only the new/changed ones? 82.43.89.71 ( talk) 17:58, 6 May 2010 (UTC)
Is it possible to limit the amount of RAM a specific program on Windows can consume? I realize this might make the program unstable or unusable, but I would like to test limiting RAM on several programs that take too much and make my overall system unusable while they're running. Thanks. 82.43.89.71 ( talk) 18:49, 6 May 2010 (UTC)
Step 2: Select the Processes tab. Check or click on show processes from all users. If you have Windows Vista you may have to allow the UAC Window that appear.
Step 3: Press "Memory" twice. That will order the processes from those using the most memory to the one using the least.
-- Tyw7 ( ☎ Contact me! • Contributions) Changing the world one edit at a time! 13:52, 8 May 2010 (UTC)
At one library I go to there is a relatively new HP mouse. I'm not touching it and as far as I know nothing is moving. I think it uses a red light rather than a ball. The arrow keeps moving all over the place, and it's hard for me to make it stand still in order to click. It will turn stuff blue at the slightest provocation, or fail to turn anything blue when I want it to, when I am copying and pasting or even just clicking to change the URL at the top of the screen. Vchimpanzee · talk · contributions · 19:57, 6 May 2010 (UTC)
They did just replace the mouse. Another one was having a great deal of difficulty doing anything. The pad is kind of rough, so I'll mention that to them. Thanks. Vchimpanzee · talk · contributions · 20:36, 6 May 2010 (UTC)
Hi all, I'm plotting some data on Excel and I'm fitting a least-squares line to it by using the "Add trendline" option on the plot of the data. I need to show where the x-intercept of the line occurs (standard addition curve, so I don't have data that far back) and I can't get excel to predict back that many periods. How can I extend the line back? Thanks for your help. 169.229.76.114 ( talk) 20:12, 6 May 2010 (UTC)
I didn't want to do that just because I didn't want an actual data point way back there, but anyways the whole thing is a moot point now. Thanks for the suggestion, though. 169.229.76.114 ( talk) 20:21, 8 May 2010 (UTC)
Hello! I have a 64-bit system with the 64-bit JRE but I also had to install the 32-bit JRE so I can run applets in Firefox, which is 32-bit. I just want to make sure that I'm using the 64-bit JRE for everything else, mainly when I call java -jar myJar
from the command prompt. java -version
doesn't tell me what architecture. What's the command that will tell me what .exe file java
is associated with? I think Linux has which
to do this, but I'm looking for how to do this with Windows. Thanks!--
el Aprel (
facta-
facienda)
20:32, 6 May 2010 (UTC)
Is it possible to import messages from Live Mail to Outlook Express? I tried Live Mail for a couple of days, and I don't like it, so I'm going back to Outlook Express. It would be handy to be able to import those messages which arrived in the time I was using Live Mail. They are still on the Googlmail server. I tried the Import wizard on Outlook Express, but it didn't give Live Mail as an option to import from. DuncanHill ( talk) 23:17, 6 May 2010 (UTC)