sqlstr="select * from customer where customername='key'"???
<%
key=request("t1")
dim Conn
set Conn=server.CreateObject ("adodb.connection")
Conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&server.mappath("customer.mdb")
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from customer where customername='key'"
rs.Open sqlstr, conn,1,1
%><%
do while not rs.eof
response.Write "<tr><td>"&rs("customername")
rs.movenext
loop
%>
我要按客户端的“T1”来查询 可是没有结果 也没提示出错 不知道红字那条语句写得对不对？
请高手帮忙～～
