为什么?莫名其妙!
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
第 1 行: ',' 附近有语法错误。
//ADD_SAVE.asp,行114
sql1 ="insert into patient(patient_Name,inter_no,zyc,patient_name,patient_sex,patient_age,patient_hf,"&_
"patient_mz,native_place,works,patient_No,State,City,Address,Zip_Code,Tel,Fax,Email,Homepage,Description,Employee_ID,Last_Updated_Employee_ID,"&_
"linkman_name,relation,linkman_adress,linkman_tel,"&_
"Inter_date,inter_type,bs,zk_type,mzzd,rysqk,ryzd,qzrq,zl_type,operation_name)"&_
" values('" & patient_Name & "','" &bah& "','" &zyc& "','" &patient_name& "','" &patient_sex& "','" &patient_age& "','" &marriage& "',"&_
"'"&nation&"','" &native_place& "','" &works& "','" &Id_card& "','" & State & "','" & City & "','" & Address & "','" & Zip_Code & "','" & Tel & "',"&_
"'" & Fax & "','" & Email & "','" & Homepage & "'," & Trade_Code & ",'" & Description & "'," & Session("Employee_ID") & "," & Session("Employee_ID") & ","&_
"'" &linkman_name& "','" &relation& "','" &linkman_adress& "','" &linkman_tel& "',"&_
"'"&inter_date&"','"&inter_type&"','"&bs&"','"&zk_type&"','"&mzzd&"','"&rysqk&"','"&ryzd&"','"&qzrq&"','"&cure_type&"','"&linkman_name&"')"
response.write sql1
conn.execute(sql1) '---->行114
打印出的语句在SQL SERVER 插入正确,但程序为什么不行?