|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Update SQL |
|
From: |
John |
|
Date: |
3/29/1999 4:42:27 PM |
|
IP: |
208.198.97.5 |
When using an update it is a batch correct? I mean that all instances should be updated? The following code will only do the first instance. Am I missing something trivial?
Function EX_Case_1()
Dim SQL, DBCase_1,CMDCase_1
Set DBCase_1 = Server.CreateObject("adodb.Connection")
Set CMDCase_1 = Server.CreateObject("adodb.command")
SQL = "Update North_pkg_" & Session("Quarter") & "_" & Session("Year") & " SET " & "Condition = '1' Where ((Condition = '2') and (Left(Location,2)= 'EX'))"
DBCase_1.Open "DRIVER=SQL Server;SERVER=localEnvironment;
CMDCase_1.ActiveConnection = DBCase_1
CMDCase_1.CommandText = SQL
CMDCase_1.Execute()
DBCase_1.Close
End Function
Thank You!! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
