need help in on_change event with sql

[choohean]

let say I have one combo box and one text box! The value in combo box are retrive from ms sql database! When I have already selected one of the value in the combo box! How I float the related value which need to retrive from the same database and same table to the text box?

Please give me some advice! By not using the on_change event also can!

 

[vbkris]

do u mean the text box must contain a value related to the item selected in the combo box?

<select name =&quot;id&quot; onchange=&quot;resubmit()&quot;>

function resubmit()
{
document.formname.action=&quot;samppage&quot;
document.formname.submit()
}

include this ASP code in the top of the page:
<%
id=request(&quot;id&quot
sql=&quot;select column from table where coulmn=&quot;+id
%>

Known is handfull, Unknown is worldfull