为何只查询到一条记录?
productshow1.asp:
<% dim zsamllclassname
zsamllclassname=trim(request("scm"))
set rs=server.CreateObject("adodb.recordset")
sqltext="select * from product where SmallClassName='" & zsamllclassname & "'"
rs.Open sqltext,conn,1,1
if rs.bof and rs.eof then
response.write "<script language=javascript>alert('No results!')</script>"
response.end
end if
%>
分别用rs("")取出值放在所需的地方..
为何只得到一条记录?(我的数据库SmallclassName)中有几条记录啊!