This topic is locked

DRIP-DOWN MENU VALUES

9/17/2003 11:04:45 AM
ASPRunnerPro General questions
swat author

hi all,
I need to set up one of my data filed as drop down menu selection , however I like to display one information and when user chooses one of the selection I will be entering into my database more information. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=173&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> ..let me make it clear <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=173&image=2&table=forumtopics' class='bbc_emoticon' alt=':huh:' />
selection:

"name" (this will be selection for users)

"phone number" (this will be hidden information)

so when user choose a name I will be entering into my database name + phone number soe that uniqe selection... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=173&image=3&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />
<"name" value = " name , phone number"> I can code something like that in html code however ......edit.asp page gets his infromation(any drop down menus) from product values.asp and I am really not sure how to set this up in that....
thanks all

swat

Sergey Kornilov 9/19/2003

Swat,
you may want to check Function BuildSelectControl(strName, strValue) in ..._aspfunctions.asp file.
You can change SQL query there to pull Name+Phone instead of pulling just Name.

if "PHONE" = Ucase(strName) then  strSQL = "select Name, Name from TableName" end if


change it to

if "PHONE" = Ucase(strName) then  strSQL = "select Name+Phone, Name from TableName" end if


Best regards,

Sergey Kornilov