读书人

速度!一个小疑点 不知道哪错了

发布时间: 2012-03-23 12:06:21 作者: rapoo

速度!一个小问题 不知道哪错了
Microsoft VBScript 编译器错误 '800a03ee '

缺少 ') '

insertsql = " ' " & now & " ', ' " & towho & " ', ' " & who & " ', ' " & email & " ', ' " & homepage & " ', ' " & message & " ', ' " & comefrom & " ', ' " & request( "R1 ") & " ' "
my_conn.execute( "insert into chat_gbook ( "addtime ", "name ", "lyname ", "email ", "homepage ", "message ", "comefrom ", "picture ") values ( " & insertsql & ") ")

[解决办法]
my_conn.execute( "insert into chat_gbook (addtime,[name],lyname,email,homepage,message,comefrom,picture) values ( " & insertsql & ") ")

[解决办法]
name与[name]有何区别?
[解决办法]
name 是关键字 要加[]的
[解决办法]
噢,我怎么觉得有时表名加不加[]都好用呢。
[解决办法]
一般来说有没有[]都行,但关键字一定要用[]
[解决办法]
不建议使用关键字做字段名,可以变换一下sName,oName,myName这样

读书人网 >ASP

热点推荐