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">&nbsp;</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:267117
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to