Database Dates equal to Current Date

2000-04-26 Thread Ryan Shrout 

This is a multi-part message in MIME format.

--=_NextPart_000_004C_01BFAF4F.8FC20E80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

How can I set up the SQL statement so that all news posts with a certain =
date are selected.  My problem is that the dates in the database have =
the date AND time, but when I try to match the datetime field with a =
#CreateODBCDate(04/25/00)# I get no matches, since their is no time =
associated with this.  Is there a way to set the time field to a =
wildcard?

Ryan Shrout
Production Manager
AthlonMB.com
http://www.athlonmb.com/
[EMAIL PROTECTED]

--=_NextPart_000_004C_01BFAF4F.8FC20E80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








How can I set up the SQL statement so =
that all news=20
posts with a certain date are selected.  My problem is that the =
dates in=20
the database have the date AND time, but when I try to match the =
datetime field=20
with a #CreateODBCDate(04/25/00)# I get no matches, since their is no =
time=20
associated with this.  Is there a way to set the time field to a=20
wildcard?
 
Ryan ShroutProduction=20
ManagerAthlonMB.comhttp://www.athlonmb.com/">http://www.athlonmb.com/mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]

--=_NextPart_000_004C_01BFAF4F.8FC20E80--

--
Archives: http://www.eGroups.com/list/cf-talk
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.

Re: Database Dates equal to Current Date

2000-04-26 Thread James Sleeman 

---Reply to mail from Ryan Shrout about Database Dates equal to Current Date

> 
> How can I set up the SQL statement so that all news posts with a certain =
> date are selected.  My problem is that the dates in the database have =
> the date AND time, but when I try to match the datetime field with a =
> #CreateODBCDate(04/25/00)# I get no matches, since their is no time =
> associated with this.  Is there a way to set the time field to a =
> wildcard?

How about 

   ...
WHERE
MyDateField GTE #CreateODBCDate(04/25/00)# AND
MyDateField LT #CreateODBCDate(04/26/00)#
   ...




--
Archives: http://www.eGroups.com/list/cf-talk
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.

RE: Database Dates equal to Current Date

2000-04-26 Thread Chris Chambers 

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

WHERE   datefield > #createodbcdatetime("04/25/00")#
AND datefield < #createodbcdatetime("04/26/00")#

_

Chris Chambers

ICQ: 40311211
AIM: CTC HOME

VOX: 757-896-6393
FAX: 757-896-0774 
_

- -Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 7:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Database Dates equal to Current Date


- ---Reply to mail from Ryan Shrout about Database Dates equal to
Current Date

> 
> How can I set up the SQL statement so that all news posts with a
> certain = date are selected.  My problem is that the dates in the
> database have = the date AND time, but when I try to match the
> datetime field with a = #CreateODBCDate(04/25/00)# I get no
> matches, since their is no time = associated with this.  Is there a
> way to set the time field to a = wildcard?

How about 

   ...
WHERE
MyDateField GTE #CreateODBCDate(04/25/00)# AND
MyDateField LT #CreateODBCDate(04/26/00)#
   ...




- --
- 
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
k or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOQcbc0ejih2dfV0dEQJIfwCfXycbHHOJ/zGLSM/VeWYcDp04YZAAn2WX
3U8g3bOhTdxXWE5xgBWZCaVF
=tqlC
-END PGP SIGNATURE-

--
Archives: http://www.eGroups.com/list/cf-talk
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.

RE: Database Dates equal to Current Date

2000-04-26 Thread Shane Pitts 

Send the variable "search" to the script::






SELECT * FROM datasource
WHERE databasedate BETWEEN #timestart# and #timeend#




-Original Message-
From: Chris Chambers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 10:38 AM
To: [EMAIL PROTECTED]
Subject: RE: Database Dates equal to Current Date


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

WHERE   datefield > #createodbcdatetime("04/25/00")#
AND datefield < #createodbcdatetime("04/26/00")#

_

Chris Chambers

ICQ: 40311211
AIM: CTC HOME

VOX: 757-896-6393
FAX: 757-896-0774
_

- -Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 7:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Database Dates equal to Current Date


- ---Reply to mail from Ryan Shrout about Database Dates equal to
Current Date

>
> How can I set up the SQL statement so that all news posts with a
> certain = date are selected.  My problem is that the dates in the
> database have = the date AND time, but when I try to match the
> datetime field with a = #CreateODBCDate(04/25/00)# I get no
> matches, since their is no time = associated with this.  Is there a
> way to set the time field to a = wildcard?

How about

   ...
WHERE
MyDateField GTE #CreateODBCDate(04/25/00)# AND
MyDateField LT #CreateODBCDate(04/26/00)#
   ...




- --
- 
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
k or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOQcbc0ejih2dfV0dEQJIfwCfXycbHHOJ/zGLSM/VeWYcDp04YZAAn2WX
3U8g3bOhTdxXWE5xgBWZCaVF
=tqlC
-END PGP SIGNATURE-


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.