[thelist] select

[Erik Goodlad]

Sounds like you don't have the datatype in the database set as a "Date/Time"
value.

If you change the datatype of the column in the database, when you do a
select the sort will be done correctly.

Erik Goodlad
_________________________________________
The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534   FAX: (949) 707-1535

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Martin
Sent: Tuesday, January 09, 2001 3:39 PM
To: thelist at lists.evolt.org
Subject: [thelist] select


is there to get the results of a sql query to sort by actual date instead
of numbered date?  for instance, right now it will give:

1/12/2000
12/03/2000
7/06/2000
9/04/2000

instead of:

1/12/2000
7/06/2000
9/04/2000
12/03/2000

any suggestions?  btw, i'm using asp if that makes a difference...  thanks!




---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !