[thelist] Q on SQL 'ORDER BY'

[Joshua Olson]

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

Walter,

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.
http://www.waetech.com/service_areas/
706.210.0168