Why not do it with a normal select? The code below will work. I personally
never use the cform pieces and you can use them in combination.
<CFQUERY NAME="court_q" DATASOURCE="yourdsn">
SELECT rowid, court_q, court_nm, county_nm
FROM sometable
WHERE somthing is true
</CFQUERY>
<SELECT NAME="rowid">
<CFOUTPUT QUERY="court_q">
<OPTION VALUE="#rowid#">#court_nm# #county_nm#
</CFOUTPUT>
</SELECT>
Mark Johnson
-----------------------
Senior Cold Fusion Developer
Cardinal Communications
-----Original Message-----
From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 4:42 PM
To: CF-Talk
Subject: Help on Pulldown - Please help...getting coldfusion rage here
is there a way to display more than one field on a pulldown menu. For
instance...the users will be choosing a Texas Court on this pulldown menu
but the Court name does not mean anything without the County name in front
of it. So, in my cfselect
<cfselect name="rowid" query="court_q" value="rowid" display="court_nm"
required="Yes"></cfselect>
I need to also display a field called county_nm when they pull down.
This is driving me crazy!!
thanks,
Kim Ahlbrandt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
