[thelist] Q on SQL 'ORDER BY'

Joshua Olson joshua at waetech.com
Fri Apr 9 19:08:38 CDT 2004

> -----Original Message-----
> From: jsWalter
> Sent: Friday, April 09, 2004 7:35 PM
>   ORDER BY jobs.job_title AND jobs.job_posted;


The correct syntax is ORDER BY jobs.job_title, jobs.job_posted

With the AND operator in there it's hard to say exactly what it's doing, but
it may be doing some sort of weird bit-wise comparison on the values if it's
not throwing an error.  Then, the remaining sort would be the databases
default based on the pk.

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list