select ID in drop down list and show name in text box without clicking submit button

[Matthew Louden]

if the user select the EmployeeID in drop down list, and then click the
submit button, and it will look up database and show the Employee Name in
the text box, this is easy.

But my case is: when the user select the employeeid in drop down list, it
will
fire the onchange event, and then look up database and show the employee
name in the text box. There is no submit button.

I really have no idea how to do that.

[Ray at]

Use client-side code to trigger a reload of the page.

<select onchange="locat ion.href='thisp age.asp?id='+th is.value">
<%

Dim iSelectedID, sName
iSelectedID = Request.Queryst ring("id")
If iSelectedID <> "" Then
sSQL = "SELECT theName FROM theTable WHERE theID=" & iSelectedID"
'etc.
%>

Ray at work

"Matthew Louden" <ma*******@hotm ail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

if the user select the EmployeeID in drop down list, and then click the
submit button, and it will look up database and show the Employee Name in
the text box, this is easy.

But my case is: when the user select the employeeid in drop down list, it
will
fire the onchange event, and then look up database and show the employee
name in the text box. There is no submit button.

I really have no idea how to do that.

[Matthew Louden]

Thanks Ray, Now I am able to get the name corresponding to the id selected
by the user.

But now to put the name printed in the text box? the following is javascript
again, and I put inside <% %> and it wont work.

document.eventf orm.empname.val ue = objRS("FirstNam e")
please help.

"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:eG******** ******@TK2MSFTN GP11.phx.gbl...

Use client-side code to trigger a reload of the page.

<select onchange="locat ion.href='thisp age.asp?id='+th is.value">
<%

Dim iSelectedID, sName
iSelectedID = Request.Queryst ring("id")
If iSelectedID <> "" Then
sSQL = "SELECT theName FROM theTable WHERE theID=" & iSelectedID"
'etc.
%>

Ray at work

"Matthew Louden" <ma*******@hotm ail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

if the user select the EmployeeID in drop down list, and then click the
submit button, and it will look up database and show the Employee Name in the text box, this is easy.

But my case is: when the user select the employeeid in drop down list, it will
fire the onchange event, and then look up database and show the employee
name in the text box. There is no submit button.

I really have no idea how to do that.

[Ray at]

<input type="text" value="<%=objRS .Fields.Item(0) .Value%>">

Ray at work

"Matthew Louden" <ma*******@hotm ail.com> wrote in message
news:eK******** ******@TK2MSFTN GP11.phx.gbl...

Thanks Ray, Now I am able to get the name corresponding to the id selected
by the user.

But now to put the name printed in the text box? the following is javascript again, and I put inside <% %> and it wont work.

document.eventf orm.empname.val ue = objRS("FirstNam e")
please help.

"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:eG******** ******@TK2MSFTN GP11.phx.gbl...

Use client-side code to trigger a reload of the page.

<select onchange="locat ion.href='thisp age.asp?id='+th is.value">
<%

Dim iSelectedID, sName
iSelectedID = Request.Queryst ring("id")
If iSelectedID <> "" Then
sSQL = "SELECT theName FROM theTable WHERE theID=" & iSelectedID"
'etc.
%>

Ray at work

"Matthew Louden" <ma*******@hotm ail.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

if the user select the EmployeeID in drop down list, and then click the submit button, and it will look up database and show the Employee Name

in

the text box, this is easy.

But my case is: when the user select the employeeid in drop down list, it will
fire the onchange event, and then look up database and show the

employee name in the text box. There is no submit button.

I really have no idea how to do that.