need a clarification.
Why do U have the <Select> inside the <cfoutput query
="GetRecord"> which means that if ur recordset "GetRecord" return 10
records it will have 10 <select>
any reason why U are doing this also I feel this is a error.
correct me if I am wrong
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
-- Phoenix Global Solutions (India) Pvt Ltd., www.pgsolutions.com
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Jeff Fongemie
<jeff@fongemi To: CF-Talk <[EMAIL PROTECTED]>
e.com> cc:
Subject: dynamic populate select box
question
08/16/01
08:38 PM
Please
respond to
cf-talk
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
