Forum Moderators: open
<form name="form1" action="">
<P align=center>Search Software:
<INPUT type=text name=txtSearch >
<INPUT type="submit" value="Go" name="submit"></P>
</CENTER>
<%
If Request.Form("submit") = "Go" Then
Set rs = Server.CreateObject("ADODB.RecordSet")
strSearch = Request.Form(txtSearch)
'get the selected software info
sqlstr = "SELECT * from LicenseTab where SwName = '"&strSearch&"' "
'Set rs = objConn.execute(sqlstr)
'Response.write "SQL = "&sqlstr
Response.Write Request.Form
<%
End if
%>
</form>
</BODY>
</HTML>
Thanks