I found it! If your Mac keeps coming up Australian, check the international language settings. Mine were set with Australian English at the top. Changed it to US English (I use Canadian or British sometimes in Windows, but it's never set me asea) and bing.com knows where I am. I may try looking for Gimp again. Not that Australian English should give me French, but I think Canadian French was listed above US English.
Xander ,'Showtime'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Ooh baby!
CrunchPad internet tablet's launch prototype looks seriously slick
We've been following the progress of Michael Arrington's CrunchPad tablet PC for some time now, but this is the first time I think I actually want one. They've just unveiled the launch prototype, and man is it slick.
This web-centric tablet should be announced officially next month, where details like pricing and availability will hopefully be made known. We'll see if it performs as well as it looks.
Ooh - it's like a GIANT iPod Touch.
I was JUST coming in to post an OMGWANT about the CrunchPad.
tommyrot, if you're gonna live in the other half of my brain, how 'bout getting my to-do list done while you're there?
how 'bout getting my to-do list done while you're there?
Sure! As long as you fix this bug that's making stuff round wrong in the SQL Server/MS Access application I'm working on....
Oh man. Want.
Shiny pretty.
Theoretical SQL question: Given a table with the columns employee number, department, and salary, can you create a SQL statement that lists the highest salary per department where the maximum salary is over $50K?
I get that you need to use the max function, a FROM subquery, and group by, but I'm blanking beyond that.
SELECT MAX(top_salary) FROM (SELECT salary AS top_salary FROM salary_table GROUP BY department) WHERE top_salary>50000
maybe?
I'm confused.
Do you want the highest salary of each department, but only if the maximum salary for that department is > 50,000?
Yes.
That's easy. Unless you want the employee number of the highest salary for each department as well. Then you need either a sub-select or the HAVING clause, I think.