日期:2014-05-17  浏览次数:20963 次

速度!一个小问题 不知道哪错了
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这样