asp代码错误,帮该一下
来源:百度知道 编辑:UC知道 时间:2024/05/22 00:23:39
<%
Products = Split(Request.Form("id"), ", ")
Set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from i_cad where id='" &Products & "'"
rs.Open sql,conn,1,3
%>
(Request.Form("id"), ", ")改为(Request.Form("id"), "or ")
Products = Split(Request.Form("id"), ", ")
Set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from i_cad where id='" &Products & "'"
rs.Open sql,conn,1,3
%>
(Request.Form("id"), ", ")改为(Request.Form("id"), "or ")
同意楼上的,ID是什么值,为什么用SPLIT分成数组?
如果是直接的ID值,那么
Products = Replace(Request.Form("id"),"'","")
就可以了。
或者不用过滤‘ 符号。 Products = Request.Form("id")
你把Request.Form("id") 分割了,就要用角码输出
<%
Products = Split(Request.Form("id"), ", ")
Set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from i_cad where id='" &Products(0) & "'"
rs.Open sql,conn,1,3
%>
sql="select * from i_cad where id="+Products
你先输出一下获取的id值,有必要用split函数吗?
难道你的id值是"12,13,45..."这种形式的吗?
这样写和ID数据类型不匹配,换中方法吧