访问数据库出错问题

[sun_lin]

语句如下
<%u_name=request.form("username_reg")
if u_name<>"" then
set db = Server.CreateObject("ADODB.Connection")
connect="Driver={Microsoft Access Driver (*.mdb)}; DBQ="& server.mappath("data.mdb")
db.Open connect
sql = "select * from users where u_name=" & u_name
set rs=db.Execute(sql)
if not rs.eof then%>
<script language="vbscript">
msgbox "用户名输入不正确，请核对后重新输入！",vbInformation,"出错提示！"
window.location="vbscript:history.back"
</script>
<%else if len(u_name)<4 then%>
出错提示如下：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
/reguser.asp, 第 7 行
也就是在执行的时候，希望各位大虾能够帮忙

[lupanfeng123]

看不懂，不好意思，好好努力

[longnights]

sql = "select * from users where u_name=" & u_name
sql语句错了
字段u_name是字符串类型,在sql中两边应该加';如果u_name是数字类型,上面的sql就对了

修改后的sql如下:
sql = "select * from users where u_name='" & u_name&"'"

[小逗狗]

sql = "select * from users where u_name=" & u_name 改成
sql = "select * from users where u_name='" & u_name &"'"

[ctb2008]

嗯,字符串类型需要加上引号(')

[heshengfen123]

路过