I'm sure it's simple but I've never had to use SQL since I'm an RPG programmer. In RPG I'd just READ a logical file over the Student table that only contained grade 12 students and then do a READE on a logical file over the Score table where the records were sorted by student_id, score desc.

I'm sure it's simple but I've never had to use SQL since I'm an RPG programmer. In RPG I'd just READ a logical file over the Student table that only contained grade 12 students and then do a READE on a logical file over the Score table where the records were sorted by student_id, score desc.

SELECT name, grade.score FROM students INNER JOIN grade ON students.id=grade.student_id ORDER BY name, score DESC;

Will get you the information you want. Not sure how to limit it to three each by name yet.

MusicMakeMyHeadPound:SELECT name, grade.score FROM students INNER JOIN grade ON students.id=grade.student_id ORDER BY name, score DESC;

Will get you the information you want. Not sure how to limit it to three each by name yet.

A friend of mine gave me this (which is I believe is MSSQL specific):SELECT DISTINCT st.name, sc.scoreFROM student st INNER JOIN Score sc ON st.id = sc.idWHERE st.grade = 12 AND sc.score IN (SELECT top 3 score FROM score WHERE score.ID = sc.id ORDER BY score desc)ORDER BY st.name

I turned it into something like this for MySQL:SELECT DISTINCT st.name, sc.scoreFROM student AS st INNER JOIN Score AS sc ON st.id = sc.idWHERE st.grade = 12 AND sc.score IN (SELECT sc.score FROM score WHERE score.id = sc.id ORDER BY score desc LIMIT 0,3)ORDER BY st.name

Unfortunately MySQL didn't like the LIMIT clause in the subquery. I noodled it around for a while and was able to figure out a different way to solve the problem - I convinced my pointy-haired boss it would be better to see all the scores rather than just the top 3 :-)

Of course I'm not actually working with students and scores but you know what I mean.

Service pack three is raping my xp box right now. It's wonder I can even post on the internets from the goddamned thing before it locks everything up. FARK THIS.

I figured I'd let automatic updates tell me when I could get it instead of trying to get it early, but apparently they didn't bother to make it work correctly, ever. If I ever stop gaming, I'll never set e-foot inside a windows box again. *sigh*

If you boot to safe mode, assuming the machine stays stable enough, you can remove sp3 there.Then I'd suggest virus/spyware/etc scanning the machine, and updating all your drivers before trying to install again.You maybe even want to run a repair install from your original XP media.

SP3 has worked correctly on most of the machines I've put it on, and 100% of the clean installs I've put it on.

gayb:Service pack three is raping my xp box right now. It's wonder I can even post on the internets from the goddamned thing before it locks everything up. FARK THIS.

I figured I'd let automatic updates tell me when I could get it instead of trying to get it early, but apparently they didn't bother to make it work correctly, ever. If I ever stop gaming, I'll never set e-foot inside a windows box again. *sigh*

Never works properly.And why would anyone, anyone, pay a monthly subscription for a program to sort-of run games on Linux when they already have a Windows OS?and have I mentioned directx 10? Because DirectX 10.

I'm not sure if this has been added by an extension I'm using or if it's part of Firefox, but tryRight Click anywhere on page -> Reload Every -> (choose time)Right Click anywhere on page -> Reload Every -> Enable

If any of you remember I've been trying to fix this guys computer. I went ahead and made the hard drive one big partition, (it was a small 33 mb partition and then one 55 gb partition) reformatted, and installed XP Home using the disks Dell provided. I figured that it would not do any harm to delete the utility partition, as I figured the malware he had installed had probably found it's way into everything.

Now, when I turn on the computer, I am asked to choose between operation systems Windows XP Home or Windows XP Home. I've booted into both and they seem to be the very same. When I go into either it shows that there is 55 gb of remaining space.

If any of you remember I've been trying to fix this guys computer. I went ahead and made the hard drive one big partition, (it was a small 33 mb partition and then one 55 gb partition) reformatted, and installed XP Home using the disks Dell provided. I figured that it would not do any harm to delete the utility partition, as I figured the malware he had installed had probably found it's way into everything.

Now, when I turn on the computer, I am asked to choose between operation systems Windows XP Home or Windows XP Home. I've booted into both and they seem to be the very same. When I go into either it shows that there is 55 gb of remaining space.

I pretty much want to make it so that he doesn't have to "choose."

What uh, what should I do?

Right click My Computer, Properties, Advanced tab, Startup and Recovery, then set the Default Operating System to one of the WinXP Home installs, then set the display OS list to 1 or 0.Done.

Fenis-Wolf:Right click My Computer, Properties, Advanced tab, Startup and Recovery, then set the Default Operating System to one of the WinXP Home installs, then set the display OS list to 1 or 0.Done.

No_47:I'm not sure if this has been added by an extension I'm using or if it's part of Firefox, but tryRight Click anywhere on page -> Reload Every -> (choose time)Right Click anywhere on page -> Reload Every -> Enable

and yeha I think it 404s when you go offline

Sounds like what I need, but not a default part of firefox-any idea what extension that might be?

Barakku:Shiat-my farky's acting up too, speaking of FF extentions, any idea why farky 1.11 would be hiding random threads? I have no filters set up...

You might email 920 about it. I think he's got a working, up-to-date version. He usually hooks up LPers, but I haven't used it in a while, so am not really paying attention. Looks like getfarky.com is still up too, but you appear to have the latest version.

Barakku:No_47: I'm not sure if this has been added by an extension I'm using or if it's part of Firefox, but tryRight Click anywhere on page -> Reload Every -> (choose time)Right Click anywhere on page -> Reload Every -> Enable

and yeha I think it 404s when you go offline

Sounds like what I need, but not a default part of firefox-any idea what extension that might be?

My desktop went pop, a capacitor gave way from what I can see (one is bulged with liquid coming out). Does anyone know if I can just build a new PC and plug my old HD in and have it boot up? Or will the NTSF file system have a cow if it sees a new MB and CPU?

- It'll bluescreen on boot if it sees a different ATA/SATA chipset than the one the old board had, but, that can be worked around by booting in safe mode and changing the driver.

- If you go from a single-core CPU to a multi-core CPU you'll need to switch the HAL that Windows is using to get the second CPU going; that's not super simply to do, but it can be done...

- Obviously you'll need to reinstall drivers for anything onboard that's different, like the audio hardware, ethernet, video etc... that's easy though, provided you don't get stuck in a chicken-n-egg problem like having no ethernet and being unable to download ethernet drivers :)

Befuddled:My desktop went pop, a capacitor gave way from what I can see (one is bulged with liquid coming out). Does anyone know if I can just build a new PC and plug my old HD in and have it boot up? Or will the NTSF file system have a cow if it sees a new MB and CPU?

If you have a Microsoft product, it might flip out over the hardware change. I hope you have your original activation key.

I think it might be part of Tab Mix Plus (which I use to modify the appearance of tabs and placement of buttons - it's actually quite cool)

Also, referring to another question, I've found that NT-based windows rarely boots with a new motherboard. Even if a machine is running and you uninstall all the drivers first. It just bluescreens and there's no way to fix it.

No_47:Also, referring to another question, I've found that NT-based windows rarely boots with a new motherboard. Even if a machine is running and you uninstall all the drivers first. It just bluescreens and there's no way to fix it.

That's the ATA driver issue I was talking about; change it to "generic IDE" before swapping boards (or in Safe Mode) and it tends to go a lot better. Otherwise you can get an INACCESSIBLE_BOOT_DEVICE bluescreen...

No_47: I'd also like to state, for the record, that there's no way in hell Kubuntu Intrepid is going to be ready by the 30th, and I suspect they'll drop back to KDE 3.5 sometime in the next couple of weeks.

This sh*t is buggy.

Would you care to elaborate? I haven't looked at Intrepid yet nor have I used KDE 4 with Hardy Heron. Are the bugs easily reproducible? Is it particular applications that are buggy or all of them?

Was/is Intrepid going to be a LTS release? I was just curious about that because Ubuntu Hardy Heron was an LTS but we Kubuntu users got a standard release.

First, the fun Ive been having. :-) It came with a webcam built into the frame above the screen. I put real vnc on it, set it in my garage, and am now sitting in my computer room watching a cricket wander around the garage. Fun! Tomorrow Im going to set it by the lizard cage. They always scurry and hide when I walk by... I know theyre up to something...

Anyway, the question : How are these people finding their stolen laptops over the internet? Unless you set up something that did something like automatically emailed yourself once a day, how would you get it back?

nosajghoul:Anyway, the question : How are these people finding their stolen laptops over the internet? Unless you set up something that did something like automatically emailed yourself once a day, how would you get it back?