create a column in your query that concatenates the data you need and
use that column in the display attribute of cfselect:
<cfquery name="request.billingRate" ...>
SELECT id, name, value, name + ' (' + value + ')' AS name_value
FROM...
....
</cfquery>
<cfselect name="billingRateID_fk" query="request.bilingRate" value="id"
display="name_value">
note: concatenation syntax is db-specific - check your db manual for
correct syntax to use!
hth
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Tony wrote:
> hello ladies and gents.
> long time, no cf-talk... quick cfselect question for ya... thanks!
>
> Billing rate:
> <br />
> <cfselect name = "billingRateID_fk" query="request.billingRate"
> value="id" display="name (value)">
> </cfselect>
>
> that will not work, because of the two values in the display attribute.
> what can i do to show two values there in that attribute, since i
> really kinda need both for the user to see.
> i supps i could just concatenate it on the database side, but if that
> wasnt possible, how would i do it?
>
> this works...
>
> Billing rate:
> <br />
> <cfselect name = "billingRateID_fk" query="request.billingRate"
> value="id" display="value">
> </cfselect>
>
> and this works...
>
> Billing rate:
> <br />
> <cfselect name = "billingRateID_fk" query="request.billingRate"
> value="id" display="name">
> </cfselect>
>
> but i just cant get the name and value, values in the attribute...
>
> thanks for any help!
>
> thanks
>
> -- tony
>
> Better than a thousand hollow words, is one word that brings peace.
> -- siddhartha gautama
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313980
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
