<cfselect query="qStates" display="state_abv" value="state_id" selected="#qUserInfo.State_ID#">
i'm not a cfform user, so i'm not sure about the pound sign usage there. On 1/23/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > Hello list, > With the HTML SELECT tag, I can populate the option with a query (for > instance, a listing of all states from a database), and then using another > query with lets say user information, I can have the users state selcted > using two queryies and CFIF statements like this: > > <select name=State_ID> > <cfoutput query=qStates> > <option value=#State_ID# <cfif qStates.StateID IS qUserInfo.State_ID> > Selected</cfif>>#State_Abv#>. > </select> > > Is this possible using CFSELECT? > > > > -- > Bruce Sorge > > "I'm a mawg: half man, half dog. I'm my own best friend!" > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
