Everything you need to know about backup and disaster recovery with AWS, for FREE!
(where Array(10,"ABC") represents an Array of Variants the way the VBScript would)
Cmd.Connection = Conn Cmd.CommandText = "SELECT * FROM TABLE WHERE FIELD1 = ? AND FIELD2 = ?" Set RS = Cmd.Execute(RecordsAffected,Array(10,"ABC"))
But this is not valid code (you can not assign an array of variants to the Cmd Parameters).
Cmd.CommandText = "SELECT * FROM TABLE WHERE FIELD1 = ? AND FIELD2 = ?" Cmd.Parameters = Array(10,"ABC") RS.Open(Cmd, adOpenDynamic, adLockPessimistic)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to resolve SQL Server DB deadlock which makes my application hangs ?||6||61|
|TSQL convert date to string||4||59|
|partitioning database after decade growth||8||59|