One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD does not exist. Unless the form is being submitted from a previous form.
Are you submitting the form right back to itself? If not, then why do you need the <CFIF> statement in the OPTIONs If so, add a form parameter at the top of the page: <cfparam name="form.timedate_period" default=""> -----Original Message----- From: Toby King [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 10:27 AM To: CF-Talk Subject: urgent help required - using a users selection to select specific data Hi there I'm really stuck on this issue - have been trying to work it out for several hours so would really appreciate some input as to what I need to do. I have displayed on screen an option where a user can select a month of a year to select specific data. <table> <form action="avgHours.cfm" method="post" name="form1"> <tr class="printhide"> <td align="center"> <b>Graph Comparison Month</b> <select name="timedate_period" onChange="document.form1.submit()"> <cfloop query="CHECK_Periods"> <option value="#timedate_id#" <cfif form.timedate_period eq Check_Periods.timedate_id>selected</cfif>>#dateformat(dateend, "mmmm yyyy")# </cfloop> </select> <input type="submit" value="Generate Report" style="font-weight:bold;color:dodgerblue;background-color:white;border:n one;"> </td> </tr> <tr class="printhide"><td> </td></tr> </form> </table> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289187 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
