Thanks for the assistance. I'll be back at it soon.
Mike
----- Original Message -----
From: "Bud" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 05, 2000 10:20 AM
Subject: Re: Dates (Newbie Problem)
> On 8/5/00, Mike Weaver penned:
> >Can someone please point me to the direction of a definitive source for =
> >coding CF date queries. I am using an access db and trying to do what I
=
> >thought would be a simple WHERE statement to find records within a date =
> >range.
>
> Should be some pretty basic things to remember.
>
> 1. Make sure you're using a Date field in the Access DB.
> 2. Enter your parameters in the query without single quotes.
> 3. Write the where statement like this:
>
> WHERE SomeDateField > #CreateODBCDate(somedate)#
> and SomeDateField < #CreateODBCDate(somedate)#
>
> 4. Most importantly, be sure you are passing a date to the query. :)
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --------------------------------------------------------------------------
----
> 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.
