请asp高手帮我看看一小段asp语句,看哪个地方有错
来源:百度知道 编辑:UC知道 时间:2024/05/28 13:53:39
<%
bigclass=request("bigclass")
smallclass=request("smallclass")
sql="select * from Product where BigClassName=" & bigclass & " and SmallClassName=" & smallclass & ""
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%>
bigclass=request("bigclass")
smallclass=request("smallclass")
sql="select * from Product where BigClassName=" & bigclass & " and SmallClassName=" & smallclass & ""
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
%>
大小写的事.
SQL语句错误.
sql="select * from Product where BigClassName=" & bigclass & " and SmallClassName=" & smallclass & ""
改为
sql=" select * from Product where BigClassName='" & bigclass & "' and SmallClassName='" & smallclass & "' "
BigClassName和SmallClassName是文本类型的吧?
你给的代码,没有发现有错误的地方,
楼主把你的错误提示贴出.