Or even WHERE expiry_date = #now()#
as Now() returns an ODBC compliant date/time stamp.
> -----Original Message-----
> From: James Smith [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 01, 2000 14:49
> To: CF-Talk
> Subject: Re: Date fields in SQL
>
>
> 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.
------------------------------------------------------------------------------
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.
