[求助]为什么这一行老说：缺少 ')'？

林中泉水发布于 2008-01-04 09:56， 532 次点击

各位前辈请帮我看一看，为什么我下边这一句代码总是说缺少缺少 ')'，为什么？

sql="Insert into kaoqing_table( user,recordYear,recordMonth,recordDay,recordTime,Iswork,note)"
values("&Session("username")&","&Cint(Year(Now()))&","&Cint(Month(Now()))&","&CintDay(Now()))&","&Time&",1,"&note&")

2 回复

madpbpl2008-01-04 10:17

这个问题不是缺少')'的问题，应该是sql语句的错误，或是数据库链接的问题
user是数据库关键字用“[]”括起来试试,如下
sql="Insert into kaoqing_table( [user],recordYear,recordMonth,recordDay,recordTime,Iswork,note)"
values("&Session("username")&","&Cint(Year(Now()))&","&Cint(Month(Now()))&","&CintDay(Now()))&","&Time&",1,"&note&")

hangxj2008-01-04 11:24

你的SQL语句本身就有问题：

sql="Insert into kaoqing_table( user,recordYear,recordMonth,recordDay,recordTime,Iswork,note)"
values("&Session("username")&","&Cint(Year(Now()))&","&Cint(Month(Now()))&","&CintDay(Now()))&","&Time&",1,"&note&")

你的第一行中的结尾为什么会有 “ " ”？
SQL语句结束的时候相反却没有了“ " ”？