Computing desk | ||
---|---|---|
< July 28 | << Jun | July | Aug >> | July 30 > |
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. |
What is the largest computer game ever made in terms of file size? Jc iindyysgvxc ( talk) 00:47, 29 July 2009 (UTC)
Are there any reliable estimates on how many different wikis are out there? Wikia claims to host at least 1,500. -- Piotr Konieczny aka Prokonsul Piotrus| talk 01:06, 29 July 2009 (UTC)
Hi All,
Is there an easy way to do this using sql: generate a table with two columns, one a field from the database and the other the number of times it occurs? Something kinda like: SELECT COUNT(CustID) AS totalOrdersFromCust FROM Orders_table WHERE CustID='id-here' except it will go and loop through the database so I end up with the number of times each customer has placed an order?
ex:
custID totalOrders 1 24 2 16
etc..
I know there's gotta be a better way the me having to write a loop with an external app.
Thanks in advance! PrinzPH ( talk) 02:16, 29 July 2009 (UTC)
Thanks Nricardo, Works! PrinzPH ( talk) 22:31, 29 July 2009 (UTC)
Hello. How can I stop my computer from turning on immediately after hibernating it? There is more than enough space for hibernation. I read an identical question but it was unhelpful.
My computer spontaneously turns on only at 8 PM (EST) everyday. Regardless of when I hibernate my computer, the hibernation finishes but the computer turns on.
I was able to hibernate my computer even when I had an Ethernet card. Thanks in advance. -- Mayfare ( talk) 03:54, 29 July 2009 (UTC)
How do I make my Ethernet card not turn on my computer when it receives packets? -- Mayfare ( talk) 16:40, 30 July 2009 (UTC)
When I run the following shell script, I expect domain names which return data to wget to be listed on the terminal where I run the script, and those which don't to be listed on /dev/pts/4. Instead, all domain names are listed on /dev/pts/4. I've tried commenting out the for loop and instead setting $line to just one domain; if I do this, it works fine. What am I doing wrong with the loop?
On a related note, when iterating wget over 2070 domains that may all be hosted on the same server, are any precautions necessary to avoid triggering the server's DoS defenses? Neon Merlin 07:05, 29 July 2009 (UTC)
#!/bin/bash IFS=" " for line in $(cat complete-scientology-domain-list.txt);do if wget -O - $line 2>/dev/null | grep ".*" >/dev/null; then echo $line else echo $line > /dev/pts/4 fi done
Are bluetooth mice any good? I'm getting a laptop and wireless mice with a small receiver and bluetooth mice seem to be in the same price range, but I've heard quite a bit of bad press towards bluetooth mice. Are they really worse than normal wireless mice? Do they interfere with WLAN much? Thanks. -- antilived T | C | G 07:11, 29 July 2009 (UTC)
Does anyone know how to update system software on a PSP 2003? Chevymontecarlo ( talk) 08:07, 29 July 2009 (UTC)
It worked - thanks. Chevymontecarlo ( talk) 10:34, 30 July 2009 (UTC)
Can vbScript handle complex numbers? If so, how does the syntax work? Thanks — Akrabbim talk 14:38, 29 July 2009 (UTC)
complete information about trackboard in computer —Preceding unsigned comment added by 116.68.94.36 ( talk) 14:58, 29 July 2009 (UTC)
A couple of kinda related linux questions
1)when i installed linux (fedora 10) i installed /boot, /, and /home as separate partitions. Now the other day i had a slight hd drive problem, and decided i needed to reinstall /boot, how can i do this without having to reinstall /, as when i used a live cd installer it told it needed to install /
2) after reinstalling fedora i used rsync under root to copy back all the files, as i had backed up / on a removable hard drive, but it doesnt seem to of copyed back programs, the files seem to be there in the backup folder but it doesn't seem to of copyed back to my pc, anyway to fix this?
3) i currently use rsync under cron doing this command "01 18 * * * root rsync --archive --compress --backup --delete --exclude-from=/home/rob/exclude / /path/to/backup/directory' and exculde the following /media/ /proc/ /sys/ /tmp/ /mnt/ /usr/share/man/
a)is there any other files/folders that can be excluded
b)would running rsysnc with any different/extra options be more beneficent?
thanks--
90.207.181.210 (
talk) 16:49, 29 July 2009 (UTC)
I have a string:
>> line = # GHZ S RI R 50.000000;
I want to grab each element as an individual string, and then convert the last into a number. After looking around, I tried this and got an error:
>> header = regexp(huh,' ','split') header = '#' 'GHZ' 'S' 'RI' 'R' '50.000000' >> str2num(header(6)) ??? Error using ==> str2num at 33 Requires string or character array input.
For all I can tell, header looks like a matrix of strings so I don't know why str2num isn't accepting it. Maybe it's just because I don't understand all this regular expression nonsense, but what am I doing wrong? Is there a better way to split this string? Thanks, — Akrabbim talk 19:04, 29 July 2009 (UTC)
>> header(6) ans = '50.000000'
— Akrabbim talk 19:40, 29 July 2009 (UTC)
Hi. I have recently purchased a 500GB Time Capsule to back up my iMac and MacBook Pro. I first set up Time Capsule on my iMac and all was hunky dory. However, when I tried to set it up on my MacBook Pro, it came up with 'Time Machine Error. The backup disk image could not be created.'. I haven't the faintest idea what this means or, more importantly, how to rectify it. Could someone help me out please? Thanks. 92.0.232.90 ( talk) 19:42, 29 July 2009 (UTC)
Can you tell me what the high watermark percentage of Apples ownership of adobe was? I know that at one time they owned more than 16% but I think the high watermark was closer to 25%. Brafferty ( talk) 20:31, 29 July 2009 (UTC)
The AutoHotkey article states that the authors released their code under the GPL, became frustrated, and then declared their future work with the code base was to be closed source. In the cited source (it's a chat board thread), the apparent author of the software states, "As we wrote all the code we can depart from the GPL if we choose. Previously downloaded source would still be under GPL (as per the license) but new copies of the source would be under whatever license we care to make."
Is this correct? I know there's very little case law in any country regarding the GPL, but I guess I had thought that once the author releases code under the GPL, he is a licensee as well, and as a user of the code, would have to abide by the GPL's terms, including releasing free, GPL'ed source code of any derivative works. If the author's statement is correct (and it does sound logical to me that he doesn't have to be a licensee) then that's an interesting wrinkle. Tempshill ( talk) 20:46, 29 July 2009 (UTC)
Is there any free software that i can use to convert dvr-ms (the format used by recorded tv from Windows Media Center) to a common format such as mpeg or avi. I have tried avidemux but the audio is really out a sync and i generally cant get it to convert correctly. Any ideas on good video conversion software or how to use avidemux properly would be greatly appreciated. —Preceding unsigned comment added by 86.177.127.22 ( talk) 21:07, 29 July 2009 (UTC)
I'm looking for a program or browser-plugin that enables downloading of flash based video from a web site, specifically this site, in a format playable by media players such as Windows media player, VLC media player or Quicktime. OS: Windows XP, or Linux (Debian or Ubuntu). Anyone aware of such a beast? -- NorwegianBlue talk 21:16, 29 July 2009 (UTC)
Addendum: I'd like to add, in case anyone else is interested, that the file was easily transcoded to a format recognizable by Windows Media Player, using the transcoding wizard of VLC media player. -- NorwegianBlue talk 22:12, 29 July 2009 (UTC)
Hello wikipedia!
Why do USB flash drives come mainly in sizes related to binary numbers? 256Mb, 1Gb, 8Gb, etc? Hard drives and CDs just have a number, presumably the biggest number they could get with the current technology.
A google search for 5gb flash drive returns a fraction of the hits for 8bg flash drive.
Thanks Fenton Bailey ( talk) 21:53, 29 July 2009 (UTC)
Computing desk | ||
---|---|---|
< July 28 | << Jun | July | Aug >> | July 30 > |
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. |
What is the largest computer game ever made in terms of file size? Jc iindyysgvxc ( talk) 00:47, 29 July 2009 (UTC)
Are there any reliable estimates on how many different wikis are out there? Wikia claims to host at least 1,500. -- Piotr Konieczny aka Prokonsul Piotrus| talk 01:06, 29 July 2009 (UTC)
Hi All,
Is there an easy way to do this using sql: generate a table with two columns, one a field from the database and the other the number of times it occurs? Something kinda like: SELECT COUNT(CustID) AS totalOrdersFromCust FROM Orders_table WHERE CustID='id-here' except it will go and loop through the database so I end up with the number of times each customer has placed an order?
ex:
custID totalOrders 1 24 2 16
etc..
I know there's gotta be a better way the me having to write a loop with an external app.
Thanks in advance! PrinzPH ( talk) 02:16, 29 July 2009 (UTC)
Thanks Nricardo, Works! PrinzPH ( talk) 22:31, 29 July 2009 (UTC)
Hello. How can I stop my computer from turning on immediately after hibernating it? There is more than enough space for hibernation. I read an identical question but it was unhelpful.
My computer spontaneously turns on only at 8 PM (EST) everyday. Regardless of when I hibernate my computer, the hibernation finishes but the computer turns on.
I was able to hibernate my computer even when I had an Ethernet card. Thanks in advance. -- Mayfare ( talk) 03:54, 29 July 2009 (UTC)
How do I make my Ethernet card not turn on my computer when it receives packets? -- Mayfare ( talk) 16:40, 30 July 2009 (UTC)
When I run the following shell script, I expect domain names which return data to wget to be listed on the terminal where I run the script, and those which don't to be listed on /dev/pts/4. Instead, all domain names are listed on /dev/pts/4. I've tried commenting out the for loop and instead setting $line to just one domain; if I do this, it works fine. What am I doing wrong with the loop?
On a related note, when iterating wget over 2070 domains that may all be hosted on the same server, are any precautions necessary to avoid triggering the server's DoS defenses? Neon Merlin 07:05, 29 July 2009 (UTC)
#!/bin/bash IFS=" " for line in $(cat complete-scientology-domain-list.txt);do if wget -O - $line 2>/dev/null | grep ".*" >/dev/null; then echo $line else echo $line > /dev/pts/4 fi done
Are bluetooth mice any good? I'm getting a laptop and wireless mice with a small receiver and bluetooth mice seem to be in the same price range, but I've heard quite a bit of bad press towards bluetooth mice. Are they really worse than normal wireless mice? Do they interfere with WLAN much? Thanks. -- antilived T | C | G 07:11, 29 July 2009 (UTC)
Does anyone know how to update system software on a PSP 2003? Chevymontecarlo ( talk) 08:07, 29 July 2009 (UTC)
It worked - thanks. Chevymontecarlo ( talk) 10:34, 30 July 2009 (UTC)
Can vbScript handle complex numbers? If so, how does the syntax work? Thanks — Akrabbim talk 14:38, 29 July 2009 (UTC)
complete information about trackboard in computer —Preceding unsigned comment added by 116.68.94.36 ( talk) 14:58, 29 July 2009 (UTC)
A couple of kinda related linux questions
1)when i installed linux (fedora 10) i installed /boot, /, and /home as separate partitions. Now the other day i had a slight hd drive problem, and decided i needed to reinstall /boot, how can i do this without having to reinstall /, as when i used a live cd installer it told it needed to install /
2) after reinstalling fedora i used rsync under root to copy back all the files, as i had backed up / on a removable hard drive, but it doesnt seem to of copyed back programs, the files seem to be there in the backup folder but it doesn't seem to of copyed back to my pc, anyway to fix this?
3) i currently use rsync under cron doing this command "01 18 * * * root rsync --archive --compress --backup --delete --exclude-from=/home/rob/exclude / /path/to/backup/directory' and exculde the following /media/ /proc/ /sys/ /tmp/ /mnt/ /usr/share/man/
a)is there any other files/folders that can be excluded
b)would running rsysnc with any different/extra options be more beneficent?
thanks--
90.207.181.210 (
talk) 16:49, 29 July 2009 (UTC)
I have a string:
>> line = # GHZ S RI R 50.000000;
I want to grab each element as an individual string, and then convert the last into a number. After looking around, I tried this and got an error:
>> header = regexp(huh,' ','split') header = '#' 'GHZ' 'S' 'RI' 'R' '50.000000' >> str2num(header(6)) ??? Error using ==> str2num at 33 Requires string or character array input.
For all I can tell, header looks like a matrix of strings so I don't know why str2num isn't accepting it. Maybe it's just because I don't understand all this regular expression nonsense, but what am I doing wrong? Is there a better way to split this string? Thanks, — Akrabbim talk 19:04, 29 July 2009 (UTC)
>> header(6) ans = '50.000000'
— Akrabbim talk 19:40, 29 July 2009 (UTC)
Hi. I have recently purchased a 500GB Time Capsule to back up my iMac and MacBook Pro. I first set up Time Capsule on my iMac and all was hunky dory. However, when I tried to set it up on my MacBook Pro, it came up with 'Time Machine Error. The backup disk image could not be created.'. I haven't the faintest idea what this means or, more importantly, how to rectify it. Could someone help me out please? Thanks. 92.0.232.90 ( talk) 19:42, 29 July 2009 (UTC)
Can you tell me what the high watermark percentage of Apples ownership of adobe was? I know that at one time they owned more than 16% but I think the high watermark was closer to 25%. Brafferty ( talk) 20:31, 29 July 2009 (UTC)
The AutoHotkey article states that the authors released their code under the GPL, became frustrated, and then declared their future work with the code base was to be closed source. In the cited source (it's a chat board thread), the apparent author of the software states, "As we wrote all the code we can depart from the GPL if we choose. Previously downloaded source would still be under GPL (as per the license) but new copies of the source would be under whatever license we care to make."
Is this correct? I know there's very little case law in any country regarding the GPL, but I guess I had thought that once the author releases code under the GPL, he is a licensee as well, and as a user of the code, would have to abide by the GPL's terms, including releasing free, GPL'ed source code of any derivative works. If the author's statement is correct (and it does sound logical to me that he doesn't have to be a licensee) then that's an interesting wrinkle. Tempshill ( talk) 20:46, 29 July 2009 (UTC)
Is there any free software that i can use to convert dvr-ms (the format used by recorded tv from Windows Media Center) to a common format such as mpeg or avi. I have tried avidemux but the audio is really out a sync and i generally cant get it to convert correctly. Any ideas on good video conversion software or how to use avidemux properly would be greatly appreciated. —Preceding unsigned comment added by 86.177.127.22 ( talk) 21:07, 29 July 2009 (UTC)
I'm looking for a program or browser-plugin that enables downloading of flash based video from a web site, specifically this site, in a format playable by media players such as Windows media player, VLC media player or Quicktime. OS: Windows XP, or Linux (Debian or Ubuntu). Anyone aware of such a beast? -- NorwegianBlue talk 21:16, 29 July 2009 (UTC)
Addendum: I'd like to add, in case anyone else is interested, that the file was easily transcoded to a format recognizable by Windows Media Player, using the transcoding wizard of VLC media player. -- NorwegianBlue talk 22:12, 29 July 2009 (UTC)
Hello wikipedia!
Why do USB flash drives come mainly in sizes related to binary numbers? 256Mb, 1Gb, 8Gb, etc? Hard drives and CDs just have a number, presumably the biggest number they could get with the current technology.
A google search for 5gb flash drive returns a fraction of the hits for 8bg flash drive.
Thanks Fenton Bailey ( talk) 21:53, 29 July 2009 (UTC)