how do you insert records into multiple tables in one form in sql 7.0 with asp

<i><b>Originally posted by : shai (edredge17@excite.com)</b></i><br /><br />Can somebody tell me how to insert multiple records in multiple table in one form in sequel with asp.

<i><b>Originally posted by : tim curtin (tcurtin@nhhartford.com)</b></i><br />'multiple data transactions should be held in transaction so that if one fails the whole transaction fails.<br /><br /><%<br /> on error resume next<br /> f1 = request("field1")<br /> f2 = request("field2")<br /> set con=server.createobject("ADODB.Connection")<br /> con.Open "MyDSN"<br /> con.beginTrans<br /> con.execute "Insert Into Table1(f1,f2) values(" & f1 & "," & f2 & ")"<br /> con.execute "Insert Into Table2(f1,f2) values(" & f1 & "," & f2 & ")"<br /> if Err.Number <> 0 then<br /> con.RollBack<br /> con.close<br /> set con = nothing<br /> response.write Err.Description<br /> else<br /> con.CommitTrans<br /> con.close<br /> set con =nothing<br /> response.write "Data inserted successfully."<br /> end if<br /> <br /><br /> <br /><br /><br /><br /><br /><br /><br /><br /><br />%><br /><br /><br />------------<br />shai at 4/30/2001 1:39:48 PM<br /><br /><br />Can somebody tell me how to insert multiple records in multiple table in one form in sequel with asp.