Hello cf-talk,
I'm stuck over how to do this.
I have a table and each record has a date field (long date format).
I need to display the records on a page where the record with the
date closest to the current date when the page is viewed will
display first, then the records whose dates are in the future in
chronological order. Something like this:
SELECT title, date, where, description, time
FROM my table
WHERE date after today
ORDER by chronological order
I can't seem to get the WHERE part right.
Any suggestions??
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
------------------------
Internet Guns For Hire
(603) 356-0768
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
