Hello cf-Talk,
I'm using a select box so a user can update a field. The field is
already populated so I run a little query called getrecord to
populate the selected option in the drop down box. Then another
query called guidepicture will populate the rest of the options (the
field is from a lookup table).
It works well, except the selected option will also show from the
second query. As an example, if 1999 was previously selected, the
1999 will show as selected, but then 1996, 1997, 1998, and 1999 will
show under the selected 1999. 1999 shows up twice.
Can I somehow get the selected option value to not show up in the
second query?
<cfoutput query="GetRecord">
<select name="guidepicture">
<option value="#guidepicture#" selected>#guidepicture#</option>
</CFOUTPUT>
<cfoutput query="guidepicture">
<option value="#guidepicture#">#guidepicture#</option>
</cfoutput>
</select>
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
------------------------
Internet Guns For Hire
(603) 356-0768
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists