Why are you doing the first query on the action page? Your unscoped vars might be pulling from the first query instead of the second.
On 1/22/07, Steve LaBadie <[EMAIL PROTECTED]> wrote: > I am having trouble getting the selection from the dropdown menu to pass > to the action page and then sent to an email address. It keeps choosing > item 1 no matter what is selected. All other variables are sent > correctly. > > > > Form Control Page > > > > <cfquery name="GetReport" datasource="empldir"> > > SELECT * > > FROM report > > ORDER BY node > > </cfquery> > > > > <tr><td width="50%" align="right"> </td> > > <td width="50%"><select name="reportID" class="formveld"><option > value="">Select Problem Printer</option><cfoutput > query="GetReport"><option > value="#reportID#">#node#</cfoutput></select></td></tr> > > > > Action Page > > > > <cfquery name="GetReport" datasource="empldir"> > > SELECT * > > FROM report > > </cfquery> > > <cfquery name="showReport" datasource="empldir"> > > SELECT node > > FROM report > > WHERE reportID = reportID > > </cfquery> > > > > Thank you for submitting a ticket to Academic Computing. You have > successfully reported a problem with printer > <cfoutput><strong>#showReport.node#</strong></cfoutput>. > > <p></p> > > This problem will be addressed as soon as possble. > > <cfmail from="#form.email#" to="[EMAIL PROTECTED]" subject="Report > a Printer Problem"> > > IP Address: #ip# > > Date Reported: #date# > > Name: #name# > > E-Mail: #form.email# > > Phone: #phone# > > Problem Machine: #showReport.node# > > Room: #room# > > Description of Problem: #desc# > > </cfmail> > > > > Steve LaBadie, Web Manager > East Stroudsburg University > 200 Prospect St. > East Stroudsburg, Pa 18301 > 570-422-3999 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > http://www.esu.edu <http://www3.esu.edu> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
