字符串的语法错误 在查询表达式
sql = "INSERT INTO users(name1,name2,namez,rank,address,tel,post,country,email,area,paynum) VALUES('"
sql = sql + trim(replace(name1,"'","’")) + "','"
sql = sql + trim(replace(name2,"'","’")) + "','"
sql = sql + trim(replace(namez,"'","’")) + "','"
sql = sql + trim(replace(rank,"'","’")) + "','"
sql = sql + trim(replace(address,"'","’")) + "','"
sql = sql + trim(replace(tel,"'","’")) + "','"
sql = sql + trim(replace(post,"'","’")) + "','"
sql = sql + trim(replace(country,"'","’")) + "','"
sql = sql + trim(replace(email,"'","’")) + "',"
sql = sql + trim(replace(paynum,"'","’")) + "',"
sql = sql + cstr(area) + ")"
'response.write sql
conn.execute sql
paynum这个是后加的,,在本身的程序上修改,,
运行就出错了,,,,
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 字符串的语法错误 在查询表达式 ' ',1)' 中。
/up/mo_ p,行 104[展开]
L***
2011-08-25 10:04:21
举报