|
 |
asp_databases thread: Updating Multiple Tables
Message #1 by imran.saleem@b... on Mon, 10 Dec 2001 10:35:56
|
|
Hi,
could someone please provide me with the syntax to update multiple
tables (3 tables). Much appreciated.
Message #2 by "Kim Iwan Hansen" <kimiwan@k...> on Mon, 10 Dec 2001 17:59:20 +0100
|
|
set cn = server.createobject("adodb.connection")
cn.open strConnect
sql = "UPDATE table1 SET field1 = '" & strField1 & "', field2 = '" & field2
& "' WHERE field3 = " & field3
cn.execute(sql)
sql = "UPDATE table2 SET field1 = '" & strField1 & "', field2 = '" & field2
& "' WHERE field3 = " & field3
cn.execute(sql)
sql = "UPDATE table3 SET field1 = '" & strField1 & "', field2 = '" & field2
& "' WHERE field3 = " & field3
cn.execute(sql)
cn.close
set cn = nothing
-Kim
-----Original Message-----
From: imran.saleem@b... [mailto:imran.saleem@b...]
Sent: 10. december 2001 10:36
To: ASP Databases
Subject: [asp_databases] Updating Multiple Tables
Hi,
could someone please provide me with the syntax to update multiple
tables (3 tables). Much appreciated.
$subst('Email.Unsub').
Message #3 by imran.saleem@b... on Mon, 10 Dec 2001 17:07:28 -0000
|
|
A colleague just advised me on the exact same solution, but thanks Kim.
-----Original Message-----
From: Kim Iwan Hansen [mailto:kimiwan@k...]
Sent: Monday, December 10, 2001 4:59 PM
To: ASP Databases
Subject: [asp_databases] RE: Updating Multiple Tables
set cn = server.createobject("adodb.connection")
cn.open strConnect
sql = "UPDATE table1 SET field1 = '" & strField1 & "', field2 = '" & field2
& "' WHERE field3 = " & field3
cn.execute(sql)
sql = "UPDATE table2 SET field1 = '" & strField1 & "', field2 = '" & field2
& "' WHERE field3 = " & field3
cn.execute(sql)
sql = "UPDATE table3 SET field1 = '" & strField1 & "', field2 = '" & field2
& "' WHERE field3 = " & field3
cn.execute(sql)
cn.close
set cn = nothing
-Kim
-----Original Message-----
From: imran.saleem@b... [mailto:imran.saleem@b...]
Sent: 10. december 2001 10:36
To: ASP Databases
Subject: [asp_databases] Updating Multiple Tables
Hi,
could someone please provide me with the syntax to update multiple
tables (3 tables). Much appreciated.
$subst('Email.Unsub').
$subst('Email.Unsub').
|
|
|
View Cart
