My aim is to pick all records out of an access DB, by date range.
I'm using the following CF:
cfquery name="bulletins"
datasource="News"
SELECT * FROM Articles
where approved
and startdate #Now()# and
expirydate #Now()#
/cfquery
Turning on debug on the server shows this ends
ct: Selecting a date range, access DB
My aim is to pick all records out of an access DB, by date range.
I'm using the following CF:
cfquery name="bulletins"
datasource="News"
SELECT * FROM Articles
where approved
and startdate #Now()# and
expiryd
Fixed it.
Ignore me.
(see those greater than signs - should have been the other way round !)
-Original Message-
From: Thomas Chiverton
Sent: Monday, February 26, 2001 3:45 PM
To: CF-Talk
Subject: Selecting a date range, access DB
My aim is to pick all records out of an access DB
[mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 10:45 AM
To: CF-Talk
Subject: Selecting a date range, access DB
My aim is to pick all records out of an access DB, by date range.
I'm using the following CF:
cfquery name="bulletins"
datasource="News"
SE
My aim is to pick all records out of an access DB, by date range.
I'm using the following CF:
cfquery name="bulletins"
datasource="News"
SELECT * FROM Articles
where approved
and startdate #Now()# and
expirydate #Now()#
/cfquery
Turning on debug on the server shows
ot; [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 9:44 AM
Subject: Selecting a date range, access DB
My aim is to pick all records out of an access DB, by date range.
I'm using the following CF:
cfquery name="bulletins"
datasource="News"
SELECT * FROM Articles
o not
generate errors.
-Andy
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 10:45 AM
To: CF-Talk
Subject: Selecting a date range, access DB
My aim is to pick all records out of an access DB, by date range.
I'm using the followin
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Try using the BETWEEN keyword.
IE WHERE StartDate BETWEEN #CreateODBCDATE(Now())# AND (A date in the
future
you set)
This will pull all the record between today and the date you specify.
If you read his SQL, he's referring to 2 different fields, so BETWEEN won't
do anything useful in this
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Subject: Re: Selecting a date range, access DB
I will be out of the office today, Monday, February 26. I will return
Tuesday, February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com
I will be out of the office today, Monday, February 26. I will
return Tuesday, February 27.
Kill this person - kill him! Oh, and remove him from the list as well g
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real
23 matches
Mail list logo