One way of doing this, although clunky, is to include another column as
month(birthday) and another one as year(birthday). You could then order by
month(birthday), year(birthday).
"Ann Harrell" <[EMAIL PROTECTED]> on 06-06-2001 03:11:39 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
cc:
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
