Garth,
No sure what you are asking here but cant you just use the order by
clause eg
select *
from table
order by date1, date2
Brian
-----Original Message-----
From: Gareth [mailto:[EMAIL PROTECTED]
Sent: Monday, 22 September 2003 3:51 PM
To: CFAussie Mailing List
Subject: [cfaussie] SQL Sorting.
Hi peoples.
I'm using MySQL for my database stuff. Just a quick question, when sorting I
have 2 fields I need to sort by,
Both are date fields, but I need to sort them like they are one field. IE
have the dates listed in the correct order at the moment all I can do is
sort one, then the other. Giving me a list of records for the one Date field
sorted seperately for the other.
If anyone can help me that would be great.
Cheers
Gareth.
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
