<cfselect> drop down processing

[NC Beach Bum]

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!

[vishu_13 · Accepted solution]

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

[NC Beach Bum]

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!