UC知道帮忙看看这个ASP哪里错了？
来源：百度知道 编辑：UC知道 时间：2024/05/22 05:43:37
<%
Dim name,word
name = Request("name")
word = Request("word")
DBPath = "nert.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBPath)
If Err.Number <> 0 Then
Err.Clear
Set conn = Nothing
Response.Write("数据库连接错误")
End If
rs.open "select * form data where name='" & name & "' and word='" & word & "'",conn,1,1
If Not rs.EOF Then
Response.Write("True")
Else
Response.Write("False")
End If
rs.Close
set rs = Nothing
%>
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
错误的信息：
Microsoft JET Database Engine 错误 '80040e14'
语法错误 (操作符丢失)
Dim name,word
name = Request("name")
word = Request("word")
DBPath = "nert.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBPath)
If Err.Number <> 0 Then
Err.Clear
Set conn = Nothing
Response.Write("数据库连接错误")
End If
rs.open "select * form data where name='" & name & "' and word='" & word & "'",conn,1,1
If Not rs.EOF Then
Response.Write("True")
Else
Response.Write("False")
End If
rs.Close
set rs = Nothing
%>
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
错误的信息：
Microsoft JET Database Engine 错误 '80040e14'
语法错误 (操作符丢失)
sql="select * form data where [name]='" & name & "' and word='" & word & "' "
set rs=conn.execute(sql)
分开写试试!!!!!应该可以了!!!!!
1、rs.open "select * form data where name='" & name & "' and word='" & word & "'",conn,1,1
中的变量 word 没有传输到这个页面
2、字段名不要使用name和变量名不要使用name
s_name等
改成这样
rs.open "select * form data where [name]='" & name & "' and word='" & word & "'",conn,1,1
name 和 word的值没有接收过来～
这个不是很清楚啊
修改name变量为其他名