< September 20 | Computing desk archive | September 22 > |
---|
| ||||||||
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions at one of the pages linked to above. | ||||||||
|
Ok so I have 2 long lists in Excel, in columns right next to each other. The first list contains all the information I need, and the second list is a partially complete version of the first. How can I sort the lists to seperate out what is in the second list but not in the first list? Xcfrommars 03:15, 21 September 2006 (UTC)
I am having problems with MIDI. I opened a MIDI with WMP 11 then I subsequently opened it in Sibelius (scorewriter) but playback wouldn't work. Then I opened it in MIDINotate Musician and playback still wouldn't work. I have done almost everything I know (checked my speaker, reset the MIDI driver, reset the sound sets in Sibelius, de-affiliated WMP 11 with MIDI, uninsalled WMP 11, etc.) Please help me! Thanks. --hello, i'm a member | talk to me! 03:36, 21 September 2006 (UTC)
Responses? --hello, i'm a member | talk to me! 02:55, 22 September 2006 (UTC)
I read in an article that a common programming exercise given to undergrad students is to write a program that prints its own source code. As a novice programmer I'm very interested. I guess the answer is recursion of some sort, but I have no ideadon't laugh how to implement it. Hints, Wikipedia? - 219.93.29.135 04:45, 21 September 2006 (UTC)
can i use my windows xp origanated ntfs filed slave drive as a slave in my osx mac computer (essentially using the slave as a big flash drive to move picture files etc back and forth) or is there an easier way to do this? (these are huge picture files... not conducive to an actual flash drive)
give me examples f use of information technology|?
I recently got more and more problems on my computer and couldn't even re-install Win98, so I bought a new hd, connected only that and everything installed just fine. So I think I've got a virus on the other hd's. So I want to install antivirus software, but the manufacturers rarely give any info on which OS's and file systems they will work on. I use different OS's (various Linux distros, Win98 and WinXP) and file systems (reiser, ext3, fat and ntfs) to prevent the spread of viruses, eg original files on fat and backups on ext3. Does this make any sense? And do all antivirus software programs cover all file systems (and which OS had I better run it from?) or do I need to install more than one? Also, are commercial programs any better than free ones? Normally I can judge for myself, but here I can't. DirkvdM 12:44, 21 September 2006 (UTC)
We are in the processing of scanning our files into the computer so the paper can be stored off-site. Some people are very nervous about this process in case the server goes down.
What is recommended as far as backing this up? Someone suggested backing up these files to DVD so they can be pulled up if there are server issues.
Any help is appreciated.
Thank you.
Consider the following two tables:
I want to get a list that looks like:
MRN | SBP | DBP |
---|---|---|
C12 | 120 | 90 |
A33 | 132 | 105 |
C97 | 118 | 92 |
Where MRN is a list of the patients - each patient listed only once. SBP and DBP are the last value of SBP and DBP. By "last value", I mean that there are many Visits per patient and I only want the last one - the one with the most recent Date.
I've been trying to write an SQL query (postgres) to do this, but it turns out to be a very hard problem. For example, a patient may see the doctor twice in one day if he/she is in the hospital. So, you can get two SBP/DBP visits on the same day and I don't want to list any patient twice. In that situation, I just want one of them (it doesn't matter which). I have figured out how to get the last SBP/DBP for a given patient:
As you can see - SBP/DBP is zero if it is not checked. So I had to add the SBP>0 and DBP>0 check. But, that is as far as I've been able to get. Any help will be greatly appreciated. -- Kainaw (talk) 14:01, 21 September 2006 (UTC)
SELECT MRN, SBP, DBP FROM patients INNER JOIN visits ON visits.MRN=patients.MRN INNER JOIN visits AS v ON visits.id=(SELECT ID FROM visits.MRN=v.MRN WHERE MRN='C12' ORDER BY Date DESC LIMIT 1)
SELECT MRN, SBP, DBP FROM patients INNER JOIN visits ON visits.MRN=patients.MRN AND visits.id=(SELECT ID FROM visits WHERE visits.MRN=patients.MRN ORDER BY Date DESC LIMIT 1)
Are you sure you don't want to list patient names in the output ? StuRat 17:50, 21 September 2006 (UTC)
i wish to take a video screen shot or to capture the screen (that has video or flash) whatever i am doing in the screen.
please anyone help me to get that software for linux? or send the link!
Hi! I have my main audio out hole taken by my speakers. WHat can I do to simultaenously listen to music and skype, on 2 different "channels" (music:speakers, skype:headphones). Thanks! PS This is not from my CD drive, where I could use its own audio-out socket. - R.
How about this: What music player (Winamp?) would let me choose my output device, in this case my CD-ROM - possible? Roughly a "splitter". - R.
Since I have the opportunity here to get info from around the world, I'm just curious as to how much both dial-up and high speed dsl costs in other countries compared to here in Canada. In fact, for all I know, one of the two (dial-up or high-speed) might be so unpopular in certain parts of the world that one is completely favoured over the other, or perhaps even that only one is even available. (I'm saying that because of my experience with renting a car in Europe...here in North America, automatic transmission is the norm, and manual is reserved either for sports cars or really, really low-end economy cars, whereas in Europe it's virtually (but not completely) impossible to rent a car with automatic transmission. I'm not sure why that's the case, but for some reason that's how things are. I'm just wondering if the same phenomenon might apply for high-speed vs. dial-up.)
In any case, what I'd really like to find out is how much it costs in various places. Here in Canada I get dial-up for about $3 a month (our dollar is worth about 90¢ US so that would amount to about $2.70 US). High speed dsl is generally about ten times that price. Something like $30-$35 US/month.
I'm just curious if there's any major difference in cost where any of you folks live. What kind of ISP service do you guys have and how much do you pay? (I'm pretty familiar with most of the major world currencies, so I can probably calculate the equivalent in Canadian dollars, but if you can, it would be great if you could express it in US$, just to save me from having to make a few dozen calculations!) Thanks! Loomis 17:49, 21 September 2006 (UTC)
In the UK, the best deal I could find is 2Mbps ADSL unlimited broadband for £15 a month or US$28.22 according to Google. For higher speeds prices are similar but can go up to around £20 a month (US$37.63) and include a download cap (see later). The highest speed in most cities is 8Mbps with rural areas are usually restricted to 1 or 2Mbps with some restricted to 64Kbps dial up. However, most broadband ISPs will give you a download cap of normally 1, 2 or 3 GBs per month although some are unlimited, however, if you want to go unlimited then you usually need to pay quite a bit more (£28 for 8Mbps unlimited (US$52.68) is not unusual). Dial-up is only slightly cheaper than low speed broadband (1Mbps) in most cases £14 a month or similar but there are also pay as you go dial up packages where you pay the cost of the telephone call to the ISP per second and nothing else. Also, something I've noticed is that the term "broadband" doesn't seem to be used outside the UK. It basically refers to higher speeds than dial up (but not ISDN). In the UK there are 2 main ways of getting broadband. If you live in a big city you can get DSL broadband through your cable TV and if not, the you get ADSL via the BT telephone network. 88.110.142.138 19:03, 21 September 2006 (UTC)
The theoretical top speed for dial-up is 56kbps but in practice this is never achieved. When I was on dial-up the top speed I could get was 32kbps so lucky you in that case. So yes, when I talk about dial up I talking about everything up to that speed. Telephone packages vary from provider to provider. In all cases, you have to pay a company for line rental (normally BT) which is the flat rate you are referring to. In general, local calls are not free, but they are very cheap (supposedly). If you use a "pay as you go" dial-up service the number that is dialed is a special "local rate" number (like premium rate numbers which I'm sure exist everywhere and charge you everything under the sun). Local rates will vary depending on who provides your telephone package but are normally around 1p per minute (US 2¢) during weekends and evenings at 3p per minute (US6¢) during the day. With these packages you only pay for the time you are online, so if you were online for 10 minutes at the weekend that may equate to 10p (US 19¢). So effectively, StuRats interpretation is correct, you pay per minute to the ISP and not a monthly charge. 88.110.142.138 20:04, 21 September 2006 (UTC)
According to their site, this version of dial up would seem to replace the graphics you see with ones optimised by your ISP. Since the graphics have been replaced with smaller files, the dial up connection takes less time to download them and that's why they claim it's faster. Note that I'm only making an assumption that this is what they do from the information on their website, I can't be sure. I've never heard of anything like it before but if my assumption is correct, then it's not really a rip off as you are getting something for your money. Whether you need or want it, is another question. 88.110.142.138 20:43, 24 September 2006 (UTC)
within the wiki software what is the code to perfom a line break? I am referring to the type of break the will prevent a new section from starting until the bottom of a captioned picture is reached.
Hello,
Does anyone know where I can find the specification for ZIP 2.0 encryption, or a Java library for managing it? It's hard to find Java libraries for ZIP encryption, as it's usually not implemented due to the known weaknesses (yet it still takes forever to crack! ;) ). Documentation is also somewhat troublesome to find, as it's usually obscured by commercial password crackers. (Also, extra kudos to anyone who can tell me the implications that the ZIP 2.0 encryption weakness entains in terms of password recovery. I didn't find any documentation on it.) Jdstroy 19:57, 21 September 2006 (UTC)
I'm getting an error that says I have too many windows open and must close some if I want to open more. This isn't true, however, as I only have a small number open. This error occurs after I've been on the comp for a while, so I suspect it's not "clearing" the record of open windows when I close them. A reboot fixes the issue, for a while. As a workaround, I'd at least like to set the max window number as high as possible. I can't seem to find that in the help files, though. So, how do I set the max open windows limit ? Also, if anyone has advice about what's the root cause of this, I'd appreciate that info, too. Thanks. StuRat 20:08, 21 September 2006 (UTC)
Does anyone know of a remotely-located ("hosted") file repository system that is free? I've looked at box.net and Xythos/Sharemation, and Streamload, but there are many limitations:
I really like the way that Sharemation works, and, to an extent, Box.net. Sharemation provides full DAV access, while Box.net provides some support for DAV.
I want something like like DAV or iFolder, where I can connect to the service as if it were a native drive. (Too bad iFolder demo died.) I really don't like file size restrictions, but I'm not too picky with storage quotas. Bandwidth quotas are rather annoying as well, but I'm sure I can manage.
Does anyone have some good finds? (I thought about using Catacomb's databased-backed DAV, as I know of several unlimited MySQL hosts... but it's slow, and I don't have Apache httpd, even though I do have Tomcat5.)
Kudos to those who read, even more to those who answer.
Jdstroy 20:26, 21 September 2006 (UTC)
file forge :) -- froth T C 22:29, 26 September 2006 (UTC)
< September 20 | Computing desk archive | September 22 > |
---|
| ||||||||
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions at one of the pages linked to above. | ||||||||
|
Ok so I have 2 long lists in Excel, in columns right next to each other. The first list contains all the information I need, and the second list is a partially complete version of the first. How can I sort the lists to seperate out what is in the second list but not in the first list? Xcfrommars 03:15, 21 September 2006 (UTC)
I am having problems with MIDI. I opened a MIDI with WMP 11 then I subsequently opened it in Sibelius (scorewriter) but playback wouldn't work. Then I opened it in MIDINotate Musician and playback still wouldn't work. I have done almost everything I know (checked my speaker, reset the MIDI driver, reset the sound sets in Sibelius, de-affiliated WMP 11 with MIDI, uninsalled WMP 11, etc.) Please help me! Thanks. --hello, i'm a member | talk to me! 03:36, 21 September 2006 (UTC)
Responses? --hello, i'm a member | talk to me! 02:55, 22 September 2006 (UTC)
I read in an article that a common programming exercise given to undergrad students is to write a program that prints its own source code. As a novice programmer I'm very interested. I guess the answer is recursion of some sort, but I have no ideadon't laugh how to implement it. Hints, Wikipedia? - 219.93.29.135 04:45, 21 September 2006 (UTC)
can i use my windows xp origanated ntfs filed slave drive as a slave in my osx mac computer (essentially using the slave as a big flash drive to move picture files etc back and forth) or is there an easier way to do this? (these are huge picture files... not conducive to an actual flash drive)
give me examples f use of information technology|?
I recently got more and more problems on my computer and couldn't even re-install Win98, so I bought a new hd, connected only that and everything installed just fine. So I think I've got a virus on the other hd's. So I want to install antivirus software, but the manufacturers rarely give any info on which OS's and file systems they will work on. I use different OS's (various Linux distros, Win98 and WinXP) and file systems (reiser, ext3, fat and ntfs) to prevent the spread of viruses, eg original files on fat and backups on ext3. Does this make any sense? And do all antivirus software programs cover all file systems (and which OS had I better run it from?) or do I need to install more than one? Also, are commercial programs any better than free ones? Normally I can judge for myself, but here I can't. DirkvdM 12:44, 21 September 2006 (UTC)
We are in the processing of scanning our files into the computer so the paper can be stored off-site. Some people are very nervous about this process in case the server goes down.
What is recommended as far as backing this up? Someone suggested backing up these files to DVD so they can be pulled up if there are server issues.
Any help is appreciated.
Thank you.
Consider the following two tables:
I want to get a list that looks like:
MRN | SBP | DBP |
---|---|---|
C12 | 120 | 90 |
A33 | 132 | 105 |
C97 | 118 | 92 |
Where MRN is a list of the patients - each patient listed only once. SBP and DBP are the last value of SBP and DBP. By "last value", I mean that there are many Visits per patient and I only want the last one - the one with the most recent Date.
I've been trying to write an SQL query (postgres) to do this, but it turns out to be a very hard problem. For example, a patient may see the doctor twice in one day if he/she is in the hospital. So, you can get two SBP/DBP visits on the same day and I don't want to list any patient twice. In that situation, I just want one of them (it doesn't matter which). I have figured out how to get the last SBP/DBP for a given patient:
As you can see - SBP/DBP is zero if it is not checked. So I had to add the SBP>0 and DBP>0 check. But, that is as far as I've been able to get. Any help will be greatly appreciated. -- Kainaw (talk) 14:01, 21 September 2006 (UTC)
SELECT MRN, SBP, DBP FROM patients INNER JOIN visits ON visits.MRN=patients.MRN INNER JOIN visits AS v ON visits.id=(SELECT ID FROM visits.MRN=v.MRN WHERE MRN='C12' ORDER BY Date DESC LIMIT 1)
SELECT MRN, SBP, DBP FROM patients INNER JOIN visits ON visits.MRN=patients.MRN AND visits.id=(SELECT ID FROM visits WHERE visits.MRN=patients.MRN ORDER BY Date DESC LIMIT 1)
Are you sure you don't want to list patient names in the output ? StuRat 17:50, 21 September 2006 (UTC)
i wish to take a video screen shot or to capture the screen (that has video or flash) whatever i am doing in the screen.
please anyone help me to get that software for linux? or send the link!
Hi! I have my main audio out hole taken by my speakers. WHat can I do to simultaenously listen to music and skype, on 2 different "channels" (music:speakers, skype:headphones). Thanks! PS This is not from my CD drive, where I could use its own audio-out socket. - R.
How about this: What music player (Winamp?) would let me choose my output device, in this case my CD-ROM - possible? Roughly a "splitter". - R.
Since I have the opportunity here to get info from around the world, I'm just curious as to how much both dial-up and high speed dsl costs in other countries compared to here in Canada. In fact, for all I know, one of the two (dial-up or high-speed) might be so unpopular in certain parts of the world that one is completely favoured over the other, or perhaps even that only one is even available. (I'm saying that because of my experience with renting a car in Europe...here in North America, automatic transmission is the norm, and manual is reserved either for sports cars or really, really low-end economy cars, whereas in Europe it's virtually (but not completely) impossible to rent a car with automatic transmission. I'm not sure why that's the case, but for some reason that's how things are. I'm just wondering if the same phenomenon might apply for high-speed vs. dial-up.)
In any case, what I'd really like to find out is how much it costs in various places. Here in Canada I get dial-up for about $3 a month (our dollar is worth about 90¢ US so that would amount to about $2.70 US). High speed dsl is generally about ten times that price. Something like $30-$35 US/month.
I'm just curious if there's any major difference in cost where any of you folks live. What kind of ISP service do you guys have and how much do you pay? (I'm pretty familiar with most of the major world currencies, so I can probably calculate the equivalent in Canadian dollars, but if you can, it would be great if you could express it in US$, just to save me from having to make a few dozen calculations!) Thanks! Loomis 17:49, 21 September 2006 (UTC)
In the UK, the best deal I could find is 2Mbps ADSL unlimited broadband for £15 a month or US$28.22 according to Google. For higher speeds prices are similar but can go up to around £20 a month (US$37.63) and include a download cap (see later). The highest speed in most cities is 8Mbps with rural areas are usually restricted to 1 or 2Mbps with some restricted to 64Kbps dial up. However, most broadband ISPs will give you a download cap of normally 1, 2 or 3 GBs per month although some are unlimited, however, if you want to go unlimited then you usually need to pay quite a bit more (£28 for 8Mbps unlimited (US$52.68) is not unusual). Dial-up is only slightly cheaper than low speed broadband (1Mbps) in most cases £14 a month or similar but there are also pay as you go dial up packages where you pay the cost of the telephone call to the ISP per second and nothing else. Also, something I've noticed is that the term "broadband" doesn't seem to be used outside the UK. It basically refers to higher speeds than dial up (but not ISDN). In the UK there are 2 main ways of getting broadband. If you live in a big city you can get DSL broadband through your cable TV and if not, the you get ADSL via the BT telephone network. 88.110.142.138 19:03, 21 September 2006 (UTC)
The theoretical top speed for dial-up is 56kbps but in practice this is never achieved. When I was on dial-up the top speed I could get was 32kbps so lucky you in that case. So yes, when I talk about dial up I talking about everything up to that speed. Telephone packages vary from provider to provider. In all cases, you have to pay a company for line rental (normally BT) which is the flat rate you are referring to. In general, local calls are not free, but they are very cheap (supposedly). If you use a "pay as you go" dial-up service the number that is dialed is a special "local rate" number (like premium rate numbers which I'm sure exist everywhere and charge you everything under the sun). Local rates will vary depending on who provides your telephone package but are normally around 1p per minute (US 2¢) during weekends and evenings at 3p per minute (US6¢) during the day. With these packages you only pay for the time you are online, so if you were online for 10 minutes at the weekend that may equate to 10p (US 19¢). So effectively, StuRats interpretation is correct, you pay per minute to the ISP and not a monthly charge. 88.110.142.138 20:04, 21 September 2006 (UTC)
According to their site, this version of dial up would seem to replace the graphics you see with ones optimised by your ISP. Since the graphics have been replaced with smaller files, the dial up connection takes less time to download them and that's why they claim it's faster. Note that I'm only making an assumption that this is what they do from the information on their website, I can't be sure. I've never heard of anything like it before but if my assumption is correct, then it's not really a rip off as you are getting something for your money. Whether you need or want it, is another question. 88.110.142.138 20:43, 24 September 2006 (UTC)
within the wiki software what is the code to perfom a line break? I am referring to the type of break the will prevent a new section from starting until the bottom of a captioned picture is reached.
Hello,
Does anyone know where I can find the specification for ZIP 2.0 encryption, or a Java library for managing it? It's hard to find Java libraries for ZIP encryption, as it's usually not implemented due to the known weaknesses (yet it still takes forever to crack! ;) ). Documentation is also somewhat troublesome to find, as it's usually obscured by commercial password crackers. (Also, extra kudos to anyone who can tell me the implications that the ZIP 2.0 encryption weakness entains in terms of password recovery. I didn't find any documentation on it.) Jdstroy 19:57, 21 September 2006 (UTC)
I'm getting an error that says I have too many windows open and must close some if I want to open more. This isn't true, however, as I only have a small number open. This error occurs after I've been on the comp for a while, so I suspect it's not "clearing" the record of open windows when I close them. A reboot fixes the issue, for a while. As a workaround, I'd at least like to set the max window number as high as possible. I can't seem to find that in the help files, though. So, how do I set the max open windows limit ? Also, if anyone has advice about what's the root cause of this, I'd appreciate that info, too. Thanks. StuRat 20:08, 21 September 2006 (UTC)
Does anyone know of a remotely-located ("hosted") file repository system that is free? I've looked at box.net and Xythos/Sharemation, and Streamload, but there are many limitations:
I really like the way that Sharemation works, and, to an extent, Box.net. Sharemation provides full DAV access, while Box.net provides some support for DAV.
I want something like like DAV or iFolder, where I can connect to the service as if it were a native drive. (Too bad iFolder demo died.) I really don't like file size restrictions, but I'm not too picky with storage quotas. Bandwidth quotas are rather annoying as well, but I'm sure I can manage.
Does anyone have some good finds? (I thought about using Catacomb's databased-backed DAV, as I know of several unlimited MySQL hosts... but it's slow, and I don't have Apache httpd, even though I do have Tomcat5.)
Kudos to those who read, even more to those who answer.
Jdstroy 20:26, 21 September 2006 (UTC)
file forge :) -- froth T C 22:29, 26 September 2006 (UTC)