ASP问题呀

<%'ASD文件如下

texta=Request.QueryString("text1")

textb=Request.QueryString("text2")

strSQL="select * from xsing jianhao='"& texta &"'"

set reset=server.CreateObject("ADODB.Recordset")

set Dtmion=server.CreateObject("ADODB.Connection")

stropen="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\数据库\web.mdb"

Dtmion.open stropen

set reset = Dtmion.Execute(strSQL)

%>

<%=reset(3)%>

'html文件部分

<form name="for1" method="post" action="asp\asp.asp">

<table width="101%" border="0">

<tr>

<th height="54" colspan="2" class="str" scope="row"> </th>

</tr>

<tr>

<th width="38%" height="27" scope="row"> </th>

<td width="62%" class="str"><input name="text1" type="text" class="str" id="text1" size="16" maxlength="16"></td>

</tr>

<tr>

<th height="32" scope="row"> </th>

<td><input name="text2" type="password" class="str" id="text2" size="16" maxlength="16"></td>

</tr>

<tr background="E|/asp?/images/main_2_33.gif">

<th height="43" colspan="2" scope="row"><div align="left" class="unnamed1">

<input name="Sub1" type="submit" class="unnamed1" value="确定">

<a href="#" class="style3">注册</a> <a href="#" class="style3">说明</a> </div></th>

</tr>

</table>

</form>

strSQL="select * from xsing jianhao='"& texta &"'"

这句有错，少个WHERE语句

这样改看看

strSQL="select * from xsing WHERE jianhao='"& texta &"'"