UC知道菜鸟请教一个简单的asp问题
来源：百度知道 编辑：UC知道 时间：2024/05/10 05:41:22
<%
m=session("usernick")
Dim ObjConn
Set ObjConn = Server.CreateObject("ADODB.Connection")
ObjConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("\library\bookstore.mdb")
ObjConn.Open
set rs= ObjConn.Execute("select * from userinfo where usernick=m ") /* 这里面的usernick=m 是错误的，问因该怎么写？*/
response.write(rs("username"))
%>
m=session("usernick")
Dim ObjConn
Set ObjConn = Server.CreateObject("ADODB.Connection")
ObjConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("\library\bookstore.mdb")
ObjConn.Open
set rs= ObjConn.Execute("select * from userinfo where usernick=m ") /* 这里面的usernick=m 是错误的，问因该怎么写？*/
response.write(rs("username"))
%>
很佩服benlao1981的勇气,连错误代码也敢贴出来.不过好像ASP不支持"+"连接符,应该是这样写吧
set rs= ObjConn.Execute("select * from userinfo where usernick='"&m&"'")
因为他是字符型,所以要用单引号,只要不是数字都要用单引号!!
set rs= ObjConn.Execute("select * from userinfo where usernick='"+m+"'")