easy:
<cfquery name="qData" ....>blah blah</cfquery>
<select name="selList" size=1>
<cfoutput query="qData"><option
value="#qData.someFieldName1#">#qData.someFIeldName2#</option>
</select>
Or
<cfselect
name = "employeeid"
size = "15"
required = "Yes"
message = "Select one of these"
query = "qData"
display ="someFieldName2"
value ="someFieldName1">
</cfselect>
Might want to look through the CF Docs.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=splash.html
CFSelect Tag:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_r-s_14.html
----------------------------------------
From: Pranathi Reddy <[email protected]>
Sent: Wednesday, March 04, 2009 9:25 PM
To: cf-talk <[email protected]>
Subject: Form Fields
Hi All,
I have an issue and my brain is not working.... Actually I am trying to pull
the data back to the formfield from sql database when there is a selection in
dropdownlist. I am really not sure of how I could realy implement it.
Any Help???????
Thanks,
Pranathi
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320128
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4