To concatinate items in the query use:
SELECT (item1 + item2) AS newitem
FROM sometable
Mark Johnson
-----------------------
Senior Cold Fusion Developer
Cardinal Communications
-----Original Message-----
From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 5:42 PM
To: CF-Talk
Subject: RE: Help on Pulldown - Please help...getting coldfusion rage
here
I'm not sure how to do that...
-----Original Message-----
From: Cami Lawson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 11:13 AM
To: CF-Talk
Subject: Re: Help on Pulldown - Please help...getting coldfusion rage
here
why don't you try concantinating the fields in your query before the
cfselect
----- Original Message -----
From: "Kim Ahlbrandt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 14, 2000 10:42 AM
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