yeah thats what i did :)
but i was just wondering if there was a cf way around it... thanks!
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Wed, Oct 15, 2008 at 10:23 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote:
> 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:314000
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
