I have a page with one text box when I search name, return value such
as (address, phone...) I show these value in the table but I want to
show these in text box that I have in my page.
<%@ Language=VBScri pt %>
<%
set conn=server.Cre ateObject ("adodb.connect ion")
connect = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" &
Server.MapPath( "customer.m db") & ";Persist Security Info=False"
conn.Open connect
%>
<html>
<head>
<script language="javas cript">
<!--
function dept_onchange(f rmSelect) {
document.frmSel ect.submit();
}
//-->
</script>
</head>
<body>
<form name="frmSelect " method="Post" action="search. asp">
Name:<input type=text name=print
onchange="dept_ onchange(frmSel ect);" />
<%
a=Request.Form ("print")
if a<> "" then
sqlstr2="select * from Ticket where Name='" & a & "'"
set ors = conn.Execute(sq lstr2)
if ors.eof=true and ors.bof=true then
Response.Write "<br><b>No Records Matched.</b>"
else
numfields=ors.f ields.count
Response.Write "<table border=1 width=100% bgcolor=#c1e0ff >"
Response.Write "<tr>"
for i=0 to numfields-1
Response.Write "<td><font color=Cornflowe rBlue face=arial
size=2><b>" & ors(i).name & "</font></b></td>"
next
Response.Write "</tr>"
ors.movefirst
do while not ors.eof
Response.Write "<tr>"
for i=0 to numfields-1
Response.Write "<td valign=top><fon t color=#000099 face=arial
size=2><b>" & ors.fields(i).v alue & " </font></b></td>"
next
Response.Write "</tr>"
ors.movenext
loop
'************** ****
Response.Write "</table>"
end if
end if
%>
<table border="1">
<tr>
<td>
<font size="2" face="arial" color="#339966" ><strong><em>
Name: </em></strong>
</font></td>
<td align="right" style="width: 184px">
<p><input name="Name" maxlength="25">
</td>
<td align="right" style="width: 184px; text-align: left">
<span style="font-size: 14pt"><p>+</p></span></td>
</tr>
<tr>
<td>
<font size="2" face="arial" color="#339966" ><strong><em>
Address:</em></strong>
</font></td>
<td align="right" style="width: 183px">
<p>
<input name="Address">
</td>
<td align="right" style="width: 183px">
</td>
</tr>
<tr>
<td>
<font size="2" face="arial" color="#339966" ><strong><em>
Phone: </em></strong>
</font></td>
<td align="right" style="width: 183px">
<p><INPUT TYPE="text" NAME="Phone" mask="(###)-###-####"
onblur="return onBlurMask(this );" onfocus="return onFocusMask(thi s);"
onkeydown="retu rn doMask(this);" style="width: 155px"></td>
<td align="right" style="width: 183px">
</td>
</tr>
<tr>
<td>
<font size="2" face="arial" color="#339966" ><strong><em>
Status:</em></strong>
</font></td>
<td align="right" style="width: 183px">
<p>
<input name="status" style="width: 183px">
</td>
<td align="right" style="width: 183px">
</td>
</tr>
<tr>
<td>
<font size="2" face="arial" color="#339966" ><strong><em>
comment:</em></strong>
</font></td>
<td style="width: 184px">
<p>
<textarea name="comment" style="width: 183px"></textarea>
</td>
<td style="width: 184px">
</td>
</tr>
<tr>
<td>
</td>
<td align="right" style="width: 184px">
<font size="2" face="arial" color="yellow">
<input type="Button" value="Save" id="submit1" name="submit1" >
<input type="reset" id="reset1" name="reset1">& nbsp;</font>
</td>
<td align="right" style="width: 184px">
</td>
<td>
</td>
</table>
</form>
</td>
<tr>
</tr>
<tr>
</tr>
</table>
</form>
</body>
</html>
