this is the error I get with that code.
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the fields
included in your query exist and that you have specified their names
correctly.
SQL = "SELECT FirstName, LastName, Birthday FROM wobinfo ORDER BY
DATEPART("m", birthday), DATEPART("d", birthday);"
Data Source = "WOBBERSMET"
> -----Original Message-----
> From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 1:14 AM
> To: CF-Talk
> Subject: RE: Another Access 2000 Date/Time Sort Thingie
>
>
> 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
