No, I think cfselect NEEDS just a field name.
You CAN do what you want directly in your query. The syntax will differ
with DBMS, but with SQLServer you can do:
<cfquery ...>
SELECT 'ratecenter '+substring(phonenum,6) as myRateField
</cfquery>
and then you could use "myRateField" in your cfselect.
-----Original Message-----
From: Kevin Mansel [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 10:31 AM
To: CF-Talk
Subject: CFSELECT Question
Ok, I know this tag pretty well, but what I am trying to do is combine two
columns and do a little formatting to them, but have that come up in the
display of the CFSELECT Tag, now i just get errors when i try to directly
apply the formatting within the "display" value of the tag, can someone
guide me in the right direction on wether this is even possible???
<cfselect name="getphonenums" query="getinformation" value="ratecenterid"
display="ratecenter #Left(phonenumber, 6)#">
thanks
kev
~~~~~~~~~~~~~~~~~
Kevin Mansel
Web Developer
Fox Communications
[EMAIL PROTECTED]
DL : 425-649-1321
C : 425-346-7221
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
