读书人

Update 语句异常请各位帮忙改改吧

发布时间: 2012-02-20 21:18:23 作者: rapoo

Update 语句错误,请各位帮忙改改吧
错误类型:
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
sql_ = "update tabPerson set Name=(trim(request( "Name "))),Sex = (request( "Sex ")) where [ID]= ' "(Request( "ID ") " '




[解决办法]
sql_ = "update tabPerson set Name= ' "&name& " ',Sex = ' "&sex& " ' where [ID]= ' "&ID& " ' "
[解决办法]
sql_ = "update tabPerson set Name= ' "&trim(request( "Name "))& " ',Sex = ' "&request( "Sex ")& " ' where [ID]= "&Request( "ID ")

字符型用 ' "&request( " ")& " ' 数值型用 "&request( " ")& "
[解决办法]
楼上正解。

[解决办法]
&&
[解决办法]
id = Request( "id ")
name = trim(Request( "name "))
sex = Request( "sex ")

sql_ = "update tabPerson set Name= ' " & name & " ',Sex = ' " & sex & " ' where [ID]= ' " & id & " '

多写两行不会死人的。

读书人网 >ASP

热点推荐