it is a datefield
-----Original Message-----
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 9:06 AM
To: CF-Talk
Subject: RE: Sorting Dates
Well, that looks like a text sorting (look at the months -- 1,12,2,3); is it
a date field?
-----Original Message-----
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 10:03 AM
To: CF-Talk
Subject: Sorting Dates
Help?
I have a column in my database that is populated with dates from today up
till the end of next year, The query does not sort the output the way it
should (the database is on SQL Server), here is what is happenning:
CFQuery:
<cfquery name="GetSchoolActivities" datasource="#DS#"
username="#DSUsername#" password="#DSPassword#">
SELECT ActivityDate
FROM Activities
WHERE ActivityDate > #CreateODBCDate(Now())#
ORDER BY ActivityDate
</cfquery>
Here's my output to web:
1/11/01
1/15/01
12/15/00
12/20/00
2/3/01
3/6/01
Why does it run January in front of December, and December in front of
February.
Thanks for your help
Jason Larson
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
