Try this:
<cfoutput>
<form action="Details.cfm" method="post">
<select name="sta">
<cfloop query=" states ">
<option value="#statecodeID#">#statename#</option>
</cfloop>
</select>
<input type="submit" value="go" name="search"/>
</form>
</cfoutput>
And on Details.cfm search for FORM.sta
Like:
<cfif IsDefined("FORM.sta") AND FORM.sta NEQ "">
<!--- Do Something Cool! --->
</cfif>
I think that is what you are trying to do - one select box with all the
states - yes?
- Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5164
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
