Do the replace in your query. select replace(fieldname, stringtoreplace, "") as displayname
On Thu, Jun 10, 2010 at 11:42 AM, Jamie Robichaud <[email protected]> wrote: > > Hi, > > Is there a way to change a string field of the CFSelect? I have a query that > will return the following: > > ABC: Some display 1 [ABC] > ABC: Some display 2 [ABC] > ABC: Some display 3 [ABC] > ... > > I basically want to have a drop down that will only display: > Some display 1 > Some display 2 > Some display 3 > ... > > I tried to use "replacenocase(some_display_name,'ABC:','')" in the display > field but get an error. What am I missing? > > > <cfselect name="some_name" > required="yes" > query="some_query" > value="some_id" > display="some_display_name"> > </cfselect> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5012 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
