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
Get the mailserver that powers this list at
http://www.coolfusion.com
