I tried your recommendation, but am still not able to get it to work
properly. For reference, I am including the code used.
<--weekly.cfm-->
<cfset today=Now()>
<cfquery name="weekly" datasource="temp">
select *
from
weekly
BETWEEN
my_date_column >= #form.start_date# and
my_date_column <= #form.end_date#
</cfquery>
<cfoutput>#Quote#<br>#Author#</cfoutput>
I am currently using an Access DB. On my database, I have the following
feilds:
QuoteID =>AutoNumber
Quote =>Memo
Author =>Memo
start_date =>Date/Time
end_date =>Date/Time
my_date_column =>Date/Time
When the page is executed, I receive the following error:
<snip>
Error Diagnostic Information
An error occurred while evaluating the expression:
#form.start_date#
Error near line 8, column 23.
----------------------------------------------------------------------------
----
Error resolving parameter FORM.START_DATE
The specified form field cannot be found. This problem is very likely due to
the fact that you have misspelled the form field name.
The error occurred while processing an element with a general identifier of
(#form.start_date#), occupying document position (8:22) to (8:38).
</snip>
-Ack!-
What do I need to correct in order to get it to work? If anyone sees what
the problem is, please include the relevent codes entirety for the fix.
A million thank you's!
Dayv
-----Original Message-----
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 4:51 PM
To: CF-Talk
Subject: RE: Weekly Date Driven Content in Cold Fusion?
Assuming your database contains a date field use the BETWEEN function in
your SQL to select records dated between Now() (ie: today) minus however
days you want to go back.
-----Original Message-----
From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]]
Sent: Friday, 20 April 2001 07:13
To: CF-Talk
Subject: Weekly Date Driven Content in Cold Fusion?
Is there a way to do a date range from start to end (e.g. a five day span)?
I want to be able to have content automatically change every week from
information being stored in a database. The information will be displayed
only if it falls within that date range criteria (I would build two fields
"start_date" and "end_date".
Is something like this possible in Cold Fusion?
TIA,
Dayv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
