More than 1 field to display in CFSELECT??

[brown]

Is there any way I can have more than one field name in DISPLAY=".." for CFSELECT? Here is my code, and I'd like the end user to be able to see more than just the tourCity field in the pop-up list. Perhaps the tourCity, tourDate, and tourVenue. Any suggestions?? Thanks.


<CFFORM action=&quot;edit_entry.cfm&quot;>
<CFSELECT name=&quot;stuff&quot; Query=&quot;tourDateList&quot; value=&quot;tourCity&quot; display=&quot;tourCity&quot;>
<OPTION SELECTED>Please select the tour city name</OPTION>
</CFSELECT>
<br><br>
<INPUT type=&quot;Submit&quot;>
</CFFORM>
Ian Hall
Multimedia Designer

http://inthepocketmedia.com

 

[iza]

you want to display tour city, tour date AND tour venue in ONE select field ??

 

[brown]

Yes, is this possible? (Because there may be more than one concert in the same city, more than one conert on the same date, etc etc...) Ian Hall
Multimedia Designer

http://inthepocketmedia.com

 

[iza]

try :
<FORM action=&quot;edit_entry.cfm&quot;>
<SELECT name=&quot;stuff&quot;>
<OPTION SELECTED>Please select the tour city name, tour Date and tour venue</OPTION>
<cfoutput query=&quot;tourDateList&quot;>
<option value=&quot;#tourCity##tourDate##tourVenue#&quot;>#tourCity#, #tourDate# at #tourVenue# </option>
</cfoutput>
</SELECT>
<br><br>
<INPUT type=&quot;Submit&quot;>
</FORM>

 

[cyrill]

Or, you can alias those fields as one in the <cfquery>:

SELECT tourCity+' '+DATANAME(yourserversyntax, tourDate)+' '+tourVebue AS theTour

 

[iza]

cyrill's tip is great !