Hmm...that doesn't make much sense to me. What happens if you run your
query in your query tool (MS-SQL Query Analyzer or similar). Do you get the
same result? What happens if you add DESC or ASC to the ORDER BY clause?
-----Original Message-----
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 10:18 AM
To: CF-Talk
Subject: RE: Sorting Dates
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
