asp牛人请进来帮我看下代码
来源:百度知道 编辑:UC知道 时间:2024/06/22 23:44:41
访问页面出现错误
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id='.
/ad.asp, line 5
ad.asp的代码为
<!--#include file="conn257/conn.asp"-->
<%
if request("fid")<>"" then
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from userinfo where id="&Request.Cookies("stprinthd1982Login")("hduid")&"",conn,1,3
if instr("111"&rs("ipcontent"),request.ServerVariables("Remote_Addr"))<1 then
rs("ipcontent")=rs("ipcontent")&request.ServerVariables("Remote_Addr")&","
rs("ipnum")=rs("ipnum")+1
rs.update
end if
rs.close
set rs=nothing
end if
Response.Redirect ".
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id='.
/ad.asp, line 5
ad.asp的代码为
<!--#include file="conn257/conn.asp"-->
<%
if request("fid")<>"" then
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from userinfo where id="&Request.Cookies("stprinthd1982Login")("hduid")&"",conn,1,3
if instr("111"&rs("ipcontent"),request.ServerVariables("Remote_Addr"))<1 then
rs("ipcontent")=rs("ipcontent")&request.ServerVariables("Remote_Addr")&","
rs("ipnum")=rs("ipnum")+1
rs.update
end if
rs.close
set rs=nothing
end if
Response.Redirect ".
最前边
response.Write Request.Cookies("stprinthd1982Login")("hduid")
一下,看看Request.Cookies("stprinthd1982Login")("hduid")这个值是否有
如果Request.Cookies("stprinthd1982Login")("hduid")是字符类型:
把
rs.Open "select * from userinfo where id="&Request.Cookies("stprinthd1982Login")("hduid")&"",conn,1,3
改成
if Request.Cookies("stprinthd1982Login")("hduid")<>"" then
rs.Open "select * from userinfo where id='"&Request.Cookies("stprinthd1982Login")("hduid")&"'",conn,1,3
end if
如果Request.Cookies("stprinthd1982Login")("hduid")是数字类型:
把
rs.Open "select * from userinfo where id="&Request.Cookies("stprinthd1982Login")("hduid")&"",conn,1,3
改成
if Request.Cookies("stprinthd1982Login")(&q