Skip to main content
Participant
April 21, 2008
Question

CFSelect Display Problem

  • April 21, 2008
  • 1 reply
  • 302 views
Hi,
I'm trying to create a cfselect using a bind. I would like to use 2 or more query columns in the "display" space of each select item. Here is my code:

<cfselect name="residents"
bind="cfc:cnyapps.Components.patientProperty.findOnlySotpResidents()"
bindonload="true" value="case_num" display="lname">
</cfselect>

I would like to display the last name (lname) AND the first name (fname), not just the last name (lname).
I would need something like display="lname,fname". Everything i have tried has come up with an error message.
How can this be done?

    This topic has been closed for replies.

    1 reply

    Inspiring
    April 21, 2008
    I'm not sure about the bind but I use a CONCAT in my SQl query statement to run the two fields together. Is that something you can use?

    I'm sure there is a user with much more experience than me that could provide a better answer. That's just the method I use...