How is the column ActivityDate defined in the table Activities?
Dick
At 9:02 AM -0700 11/27/00, Jason Larson wrote:
>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/cf-talk@houseoffusion.com/
>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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
