> Here is the code:
>
> <cfquery name="gettype" datasource="samples"> SELECT * FROM
> member_type ORDER BY type </cfquery>
>
> <cfform format="flash" name="AskESU" width="500">
> <cfformgroup type="panel" label="Ask ESU" height="400">
> <cfselect enabled="yes" visible="yes" name="typeID"
> label="Select:"> <option value="" selected="selected">Select
> Department</option> <cfoutput query="gettype"><option
> value="#typeID#">#type#</option></cfoutput>
> </cfselect>
> <cfinput type="text" name="firstName" label="First Name:">
> <cfinput type="text" name="lastName" label="Last Name:">
> <cfinput type="text" name="email" label="Email:"
> pattern="^\w+([\.-]?\w+)[EMAIL PROTECTED]([\.-]?\w+)*(\.\w{2,3})+$"
> validate="regular_expression" required="yes" message="You
> must enter a valid E-Mail Address"> <cfinput type="text"
> name="confirm" label="Confirm Email:" > <cftextarea cols="30"
> rows="5" name="comments"
> label="Comments:"></cftextarea>
> <cfinput type="submit" name="submit" value="Ask">
> </cfformgroup> </cfform>
Instead of using CFOUTPUT to populate your CFSELECT, try using the QUERY,
VALUE, DISPLAY, and QUERYPOSITION attributes.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248313
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
