Shouldn't you use <cfset today = DateFormat(now(), "DD-MMM-YY")> and also I
think ID is a reserved word in access, try using AdvertID instead (or
something similar).
--
James Smith
[EMAIL PROTECTED]
----- Original Message -----
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, October 01, 2000 2:24 PM
Subject: Date fields in SQL
> Hi,
>
> Well it's another Query problem for Will today - the error message is
> telling me it can't find expiry_date field - in Access I've set the
> date/time format to a custom dd-mmm-yy - is this the problem? Here's the
> code:
>
> <Cfset today = #DateFormat(Now())#>
>
> <cfquery name="adverts" datasource=#ds#>
> SELECT id FROM advert_details
> WHERE expiry_date = #today#
> </cfquery>
>
> ODBC Error Code = 07001 (Wrong number of parameters)
>
>
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
>
>
>
> Any ideas?
>
> Thanks, again all.
>
>
>
> Will
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
