数据能按正确格式写入，但是任然报错，求高手解答 - 编程论坛

#2

eournet2013-09-23 19:32

sql="insert into b3(huohao,title,shulian,id_danwei,price1,price2,bigclass,id_gys,id_produit,id_huiyuan,price,id_ku,bzr,gys,type,selldate,enddate,id_login,login,bianhao,beizhu,ybf,jxf,grxs,fcf,aqf,gj) values('"&nowhuohao&"','"&nowtitle&"',"&nowshulian&",'"&nowid_danwei&"',"&nowprice1&","&nowprice2&","&nowbigclass&",'"&nowid_gys&"','"&nowid_produit&"','"&nowid_huiyuan&"','"&nowprice&"','"&rs_ku("ku")&"','"&nowbzr&"','"&nowgys&"','"&nowtype&"',#"&nowselldate&"#,#"&nowenddate&"#,"&nowid_login&",'"&rs_login("username")&"','"&nowbianhao&"','"&nowbeizhu&"',"&nowybf&","&nowjxf&","&nowgrxs&","&nowfcf&","&nowaqf&","&nowgj&")"
conn.execute(sql)

#3

ysf01812013-09-24 12:12

这么写会理解很多。

rs.addnew
rs("字段") = 值
rs.update

#4

eournet2013-09-24 17:05

这样写代码太长啊

#5

eournet2013-09-24 17:39

set rs=server.createobject("ADODB.RecordSet")
sql="select * from b3j where 1=2"
rs.open sql,conn,1,3
rs.addnew
'if CInt(mon)<>CInt(hand*bz) then
'nowjggr=formatnumber(nowprice2*nowshulian,2)
'nowpggr=formatnumber(nowprice1*nowshulian,2)
'end if
rs("huohao")=nowhuohao
rs("title")=nowtitle
rs("shulian")=nowshulian 仍然显示这行：类型不匹配，我实在弄不明白，都看过了，请指教
rs("id_danwei")=nowid_danwei
rs("price1")=nowprice1
rs("price2")=nowprice2
rs("bigclass")=nowbigclass
rs("id_gys")=nowid_gys
rs("id_produit")=nowid_produit
rs("id_huiyuan")=nowid_huiyuan
rs("price")=nowprice
rs("id_ku")=nowid_ku
rs("bzr")=nowbzr
rs("gys")=nowgys
rs("type")=nowtype
rs("selldate")=nowselldate
rs("enddate")=nowenddate
rs("id_login")=nowid_login
rs("login")=rs_login("username")
rs("bianhao")=nowbianhao
rs("beizhu")=nowbeizhu
rs("ybf")=nowybf
rs("jxf")=nowjxf
rs("grxs")=nowgrxs
rs("fcf")=nowfcf
rs("aqf")=nowaqf
rs("gj")=nowgj
rs("jggr")=formatnumber(nowprice2*nowshulian,2)
rs("pggr")=formatnumber(nowprice1*nowshulian,2)
'rs("jggr")=nowjggr
'rs("pggr")=nowpggr
rs.update
rs.close

#6

eournet2013-09-24 19:10

我在前面加了
if nowshulian="" then
nowshulian=0
end if
就正常了