关于asp 同时写入数据库不同的两个表！！急！！

strSQL="insert into dingdan(shopid,ordernum,memberzhanghao,productnum,productprice,productshuliang,orderstate,fanlistate,yongjin,inputdate) values('" &m_id& "','" &o_cd & "','" &u_id& "','" &p_cd& "'," &price& "," &it_cnt& ",0,0," &comm*.6& ",'" &date& "')"
conn.execute strSQL

strSQL="insert into orders(receipt,orderid,userid,postcode,goods,address,state,fanlistate,productnum,remarks) values('" &m_id& "','" &o_cd & "','" &u_id& "','" &p_cd& "'," &price& "," &it_cnt& ",0,0," &comm*.6& ",'" &date& "')"
conn.execute strSQL