just trying to USE the tools as they are :) and see how far they get me...
no other good reason :)
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Wed, Oct 15, 2008 at 10:43 PM, Charlie Griefer
<[EMAIL PROTECTED]> wrote:
> why not just use a <select> ?
>
> On Wed, Oct 15, 2008 at 7: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:314001
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
