use datepart function to sort by:
SELECT FirstName, LastName, Birthday, Met, Email, Address1, City, State,
Zip, Phone
FROM wobinfo
ORDER BY DATEPART("m", birthday), DATEPART("d", birthday);
HTH
Dan
(note the datepart function is slightly different syntax in access and SQL)
-----Original Message-----
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 06:42
To: CF-Talk
Subject: Another Access 2000 Date/Time Sort Thingie
I have a list of birthdays here:
http://ann.bourbon.hoosierlink.net/Wob/BirthdayForm.cfm
Right now I have all the years at 2001 and 2002 so they will sort correctly,
by month. What I want is to be able to have have them sort by the month then
day then year.
so they might apear as
January 26, 1956
January 31, 1960
February 2, 1948
March 30, 1970
Dates are entered in the Access Database:
1/26/1956
1/31/1960 ect.
<CFQUERY NAME="GetBirthday" DATASOURCE="wobbersmet">
SELECT FirstName, LastName, Birthday, Met, Email, Address1, City, State,
Zip, Phone
FROM wobinfo
WHERE Birthday > (Now())
ORDER BY WobInfo.Birthday
</CFQUERY>
<cfinclude template="Toolbar.cfm">
<TABLE WIDTH="50%" BORDER="0" CELLSPACING="2" CELLPADDING="2">
<TH>First Name</TH> <TH>Last Name</TH><TH>Birthday!</TH>
<CFOUTPUT QUERY="GetBirthday">
<TR BGCOLOR=#IIF(getbirthday.currentrow MOD 2, DE ('FFFFFF'), DE
('FFFFDF'))#>
<TD>#FirstName#</TD><td>#LastName#</td><TD>#DateFormat(Birthday, "mmmm
dd, yyyy dddd")#</TD>
</TR>
</CFOUTPUT>
</TABLE>
</TABLE>
Ann Harrell
Harrell Computer Enterprises
Phone: 219.342.0618
eFax: 603.843.9212
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
