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

Reply via email to