编程 语句未结束 帮我看下哪错

来源：百度知道 编辑：UC知道 时间：2024/06/28 13:21:05
sql="insert into hyxx(user_name,password,user_code,question,answer,user_email,city,big_class,pub_quanpin,pub_jian_name,pub_shu_name,pub_fun,pub_rename,pub_tel,pub_address,pub_post,pub_url,pub_intro,pub_name,date) values('" & user_Name & "','" & password & "','" & user_code & "','" & Question & "','" & Answer & "','" & user_email & "','" & city & "','" & big_class & "','" & pub_quanpin & "','" & pub_jian_name & "','" & pub_shu_name & "','" & pub_fun "','" & pub_rename & "'," & pub_tel & ",'" & pub_address & "'," & pub_post & ",'" & pub_url & "','" & pub_intro & "','" & pub_name & "','" & datenow & "')"

pub_fun 这个后面少了一个&

你这句话太多了，没细看，这种如果添加的不多还行，多了的话，写的太多，容易出错，不如写成这个

rs.add
rs("user_name")=user_name
....
rs.updata

电话号码和邮编是不是数字型字段，如果不是，就错在这里。

" & pub_post & " 这地方的引号错了

insert into hyxx(user_name,password,user_code,question,answer,user_email,city,big_class,pub_quanpin,pub_jian_name,pub_shu_name,pub_fun,pub_rename,pub_tel,pub_address,pub_post,pub_url,pub_intro,pub_name,date) values('" & user_Name & "','" & password & "','" & user_code & "','" & Question & "','" & Answer & "','" & user_email & "','" & city & "','" & big_class & "','" & pub_quanpin & "','" & pub_jian_name & "','" & pub_shu_name & "','" & pub_fun & "','" & pub_rename & "'," & pub_tel & ",'" & pub_address