Your WHERE clause in the 2nd query doesn't look correct. What DB are you using? You
usually need quotes around dates. Try using <cfqueryparam cfsqltype="CF_SQL_DATE"
value="#CreateODBCDate(yourdate)#"> for the dates. You should be using cfqueryparam
anyway.
Pascal
-----Oorspronkelijk bericht-----
Van: Kim M. Inganamort [mailto:[EMAIL PROTECTED]
Verzonden: wo 20/08/2003 7:50
Aan: CF-Talk
CC:
Onderwerp: help... spitting out date choices...
I am trying to spit out dates for a newsletter so visitors can choose a
date and proceed to that newsletter... all i think i need is the date
chosen and thrown to the next page so i can use the date chosen as a
variable off that.
The code I have now to spit it is as follows:
<CFFORM ACTION="stackView.cfm" METHOD="Post">
<SELECT NAME="reportDate">
<CFOUTPUT QUERY="getvalidreports">
<OPTION VALUE="#reportDate#">#reportDate#
</CFOUTPUT>
</SELECT>
<INPUT TYPE="submit" VALUE="Submit">
</CFFORM>
reportDate is a field in my database for the date of the newsletter
getvalidreports is a query that pulls all reports since user started
subscribing.
I figured a drop down would be neatest... I have made it now so that
there are no errors, but no
<http://itxt.vibrantmedia.com/al.asp?ipid=20&cc=us&di=32203&ts=367549&re
dir=> data fills the dropdown box... its empty... 0 records created
from getvalidreports query
By the way...
here are my queries:
<cfquery name="getuseraccount" datasource="commodityHistory">
Select start
FROM
<http://itxt.vibrantmedia.com/al.asp?ipid=20&cc=us&di=32095&ts=367549&re
dir=> Accounts
Where username = '#session.username#'
</cfquery>
<cfoutput query="getuseraccount">
<cfquery name="getvalidreports" datasource="commodityHistory">
SELECT * FROM price WHERE reportDate between #dateformat(start,
"yyyy-mm-dd")# and #dateformat(NOW(), "yyyy-mm-dd")#
</cfquery>
</cfoutput>
anyone have any thoughts?
Thanks for your input.
Kim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
