Combine the two fields in your query.
In Oracle it would be like this:
select county_nm || ' - ' || court_nm court_display
In Access I believe it is:
select count_nm & ' - ' & court_nm as court_display
HTH,
Dan
-----Original Message-----
From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 8:42 AM
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists