asp mysql odbc 5.3_asp读取数据库，运行提示[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.19]You have an error in your ...

运行提示[MySQL][ODBC5.3(w)Driver][mysqld-5.5.19]YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'Hour_Minute)...

运行提示

[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.19]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Hour_Minute)values('542671','','2015/03/23','12312','ww','非冷链','2','预约' at line 1

\wwwroot\bookingRegistration\bookingRegistration_add_save.asp, line 206

我的sql语句

sql="insert into subscribeclient(SubscribeNo,CarNo,HGcdsy,HGsshd,HGhwpm,HGclxh,HGsscd,HGgpf,AddedBy,ModifiedBy,MsgStatus,PingGuiShu,Hour_Minute)values('" &pk&"','"& bookingregcarno &"','"& bookingreghgcdsy & "','" & bookingreghgsshd & "','" & bookingreghghwpm & "','" & bookingreghgclxh & "','" & bookingreghgsscd & "','" & bookingreghggpf & "','" & loginUser & "','" & loginUser & "','"&msg&"','"&PingGuiShu&"','"&bookingreghour_minute&"')"

展开