you could probably drop it to
WHERE expiry_date = #CreateODBCDateTime(now())#
if you wanted.
> I used to #createodbcdate# function as shown below which has worked great.
>
> WHERE expiry_date = #createodbcdate(DateFormat(now(), "DD-MMM-YY"))#
>
> Cheers
>
> Will
>
> ----- Original Message -----
> From: "James Smith" <[EMAIL PROTECTED]>
> Newsgroups: cf-talk
> Sent: Sunday, October 01, 2000 2:28 PM
> Subject: Re: Date fields in SQL
>
>
> > 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/[email protected]/
> > > 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/[email protected]/
> > 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/[email protected]/
> 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/[email protected]/
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.
