Hi Kim, Couple of suggestions.
Do these queries work OK when run directly against the database (cut out all the other layers)? Is 'start' a reserved word in one of the layers between your CF code and the database? Is the first query returning a value? If in doubt <CFDUMP var="#getuseraccount#"> ! Michael Traher Systems Manager ICLP (London) -----Original Message----- From: Kim M. Inganamort [mailto:[EMAIL PROTECTED] Sent: 20 August 2003 06:51 To: CF-Talk Subject: 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
