Skip to main content
N
NC Beach Bum
Participant
August 2, 2013
Answered

<cfselect> drop down processing

  • August 2, 2013
  • 1 reply
  • 485 views

Hi -

I have a query with Names and Phone Numbers.   I am trying to use <cfselect> statement to provide the list of names in the drop down.   Then when the user selects the name and the system passes the phone number associated with that person for processing.  I do not want the user to see the phone number but only a name.    I have put hours in this and it's not happening.  Your help is much appreciated!  

Thanks!

This topic has been closed for replies.
Correct answer vishu_13

Hi

Can  you share your code for the same?

Also, can you try the code mentioned below

<cfquery datasource="vishal_db" name="vishal">

   

    select Person_ID, First_Name, Last_Name

    from vishal_table

   

   </cfquery>

<cfform name="test" format="XML" skin="basic">

   

   

    <cfselect name="Employee" style="width:200" label="Employee" query="vishal" value="First_Name" >

     </cfselect>

   

   

</cfform>

Thanks

VJ

1 reply

vishu_13
vishu_13Correct answer
Inspiring
August 5, 2013

Hi

Can  you share your code for the same?

Also, can you try the code mentioned below

<cfquery datasource="vishal_db" name="vishal">

   

    select Person_ID, First_Name, Last_Name

    from vishal_table

   

   </cfquery>

<cfform name="test" format="XML" skin="basic">

   

   

    <cfselect name="Employee" style="width:200" label="Employee" query="vishal" value="First_Name" >

     </cfselect>

   

   

</cfform>

Thanks

VJ

N
NC Beach BumAuthor
Participant
August 5, 2013

Thanks very much for your help.  In reviewing your code I immediatly realized the issue in my code.  I tested and it's now working.  Excellent! 

Thanks for the assist! 

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices