Thanks very much! I can see where I have erred.
Mike
----- Original Message -----
From: "Christopher S Martin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 05, 2000 9:25 AM
Subject: Re: Dates (Newbie Problem)
> You can get around the division by zero error by enclosing your date
> variable in single quotes in an sql query e.g.
>
> '#this is somedate#'
>
> You also want to make sure your acess filed is storing the dates as a
> date/time field, not as a text field.
> to find stuff within a date range, try this:
>
> <cfquery name="qcfdateSortAction" datasource="FSLibraryTest">
> SELECT *
> FROM tblDates
> WHERE EventBeginDate BETWEEN #form.beginMonth# and #form.endMonth#
> ORDER BY EventBeginDate
> </cfquery>
>
> if you want to look for a specific month you could try:
>
> <cfquery name="qcfsearchByDate" datasource="FSLibraryTest">
> SELECT *
> FROM tblIndustryEvents
> WHERE EventBeginDate <= #SearchDate#
> and EventEndDate >= #SearchDate#
> </cfquery>
>
> Hope this helps.
>
> ----- Original Message -----
> From: "Mike Weaver" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, August 05, 2000 13:29
> Subject: Dates (Newbie Problem)
>
>
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_0007_01BFFEC8.17DAE900
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > 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. I have searched the archives as well as recent emails to no =
> > avail. I receive division by zero error or data mismatch errors =
> > depending on the type of query I am trying. I have used the default =
> > date in the record sets as well as the DateNow()
> >
> > All help is greatly appreciated. I have learned a lot from this =
> > resource.
> >
> > Thank You
> >
> > Mike
> >
> > ------=_NextPart_000_0007_01BFFEC8.17DAE900
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META http-equiv=3DContent-Type content=3D"text/html; =
> > charset=3Diso-8859-1">
> > <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=3D#ffffff>
> > <DIV><FONT face=3DArial size=3D2>Can someone please point me to the =
> > direction of a=20
> > definitive source for coding CF date queries. I am using an access
=
> > db and=20
> > trying to do what I thought would be a simple WHERE statement to find =
> > records=20
> > within a date range. I have searched the archives as well as =
> > recent emails=20
> > to no avail. I receive division by zero error or data mismatch errors =
> > depending=20
> > on the type of query I am trying. I have used the default date in
=
> > the=20
> > record sets as well as the DateNow()</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> > <DIV><FONT face=3DArial size=3D2>All help is greatly appreciated. I have
=
> > learned a=20
> > lot from this resource.</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Thank You</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Mike</FONT></DIV></BODY></HTML>
> >
> > ------=_NextPart_000_0007_01BFFEC8.17DAE900--
> >
>
> --------------------------------------------------------------------------
> ----
> > 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.
