Syntaxis for INSERT?

[gcastillo]

Which is the exact syntaxs for an INSERT statment in two tables?? I have two tables, in table1 I have the fields w, x, y, z. In my table2 I have the fields y, z. How can i insert the data in both tables in just one operation?
Thank you!

 

[JrClown]

do this
SQL #1
SQL1="INSERT INTO table1 (W,X,Y,Z) Values ("&_
"'"& request.form("W&quot& "', " &_
"'"& request.form("X&quot& "', " &_
"'"& request.form("Y&quot& "', " &_
"'"& request.form("Z&quot& "')"
Dim RS1
set RS1=server.createobject("adodb.recordset&quot
RS1.open SQL1, "dsn=mydb"
%>

SQL #2
SQL2="INSERT INTO table1(Y,Z) Values ("&_
"'"& request.form("Y&quot& "', " &_
"'"& request.form("Z&quot& "')"
Dim RS2
set RS2=server.createobject("adodb.recordset&quot
RS2.open SQL2, "dsn=mydb"
%>




QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>

 

[JrClown]

I forgot the <% below do this and you don't need the one between both SQL's
just at the top and bottom, but you knew that QUOTE OF THE DAY
Not to know if bad; not to wish to know is worse.
<%
Jr Clown
%>