Question

asp中sql按变量查询问题

A页
<a href="product_woodframe.asp?type=wood">'A页设定变量type等于值wood

B页
set conn=server.createobject("adodb.connection")
conn.open("DRIVER={sql server};server=web;uid=sa;pwd=Jchoman+0#;database=jihua")
set Recordset1=server.createobject("adodb.recordset")
sql= "SELECT * FROM dbo.product_all WHERE 类型=Request.QueryString("type")"
'这里的条件查询按A页的type值来查询该怎么写?

Answer 1

这样写就可以了： sql= "SELECT * FROM dbo.product_all WHERE 类型='"&Request.QueryString("type")&"'"