-
Updating multi tables
Friends,
I'm looking for a way to update the multi tables with an sql statement with an condition
Set connRE = Server.CreateObject("ADODB.Connection")
myDSN="DSN=DNS;User Id=user;password=password"
connRe.Open myDSN
sqltemp= "Insert into table1 (field1, field2) values(value1, values)
//lost right here
//If value not in table 2 than insert the field into the table.
insert into table2(field1, field2) values(value1, values)
set rstemp=connRE.execute(sqltemp)
set rstemp=nothing
connRE.close
set connRE=nothing