Ciao a Tutti,
volevo sapere per cortesia se c' era un modo di compattare il seguente codice:
Set cn = Server.CreateObject("ADODB.Connection")
Set cn_cu = Server.CreateObject("ADODB.Connection")
cn.ConnectionString = "DSN=4_plan.dsn"
cn_cu.ConnectionString = "DSN=3_custom.dsn"
cn.Open
cn_cu.Open
Set cmd=CreateObject("adodb.command")
Set cmd_cu=CreateObject("adodb.command")
With cmd
Set .ActiveConnection = cn
.CommandType=1 'adCmdText
.CommandText = sql3
.Execute , , 128 '128=adExecuteNoRecords
.CommandText = sql4
.Execute , , 128
End With
With cmd_cu
Set .ActiveConnection = cn_cu
.CommandType=1 'adCmdText
.CommandText = sql5
.Execute , , 128
End With
'
cn.Close
cn_cu.Close
Set cn=nothing
Set cn_cu=nothing
Grazie mille in anticipo !!!
P.S. volevo sapere se e' possibile ad esempio mettere 2 "Set" su di una stessa riga, ecc...