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这样