读书人

语法异常 (操作符丢失) 在查询表达式

发布时间: 2012-02-21 16:26:23 作者: rapoo

语法错误 (操作符丢失) 在查询表达式 'Name =' 中。
<!--#include file= "../include/DBConnection.asp "-->

<%

Dim str,sql_

str=Request( " Name ")

sql_ = "delete From tabPerson where Name = " & str

Conn.Execute sql_

CloseConn conn
set upload=nothing
response.Redirect( " ")

%> 怎样改阿?

[解决办法]
str=Request( "Name ")
Request后面引号内不要空格。
[解决办法]
sql_ = "delete From tabPerson where Name = ' " & str& " ' "
[解决办法]
是不是又是?跟name之间有空格的原因?
[解决办法]
<!--#include file= "../include/DBConnection.asp "-->

<%

Dim str,sql_

str=Request( "Name ")

sql_ = "delete From tabPerson where [Name] = ' " & str & " ' "

Conn.Execute sql_

CloseConn conn
set upload=nothing
response.Redirect( " ")

%>
[解决办法]
str=trim(Request( "Name "))

读书人网 >ASP

热点推荐