Jim Buyens can you help me again?

[Guest]

I'm trying to execute multiple update commands and I'm getting the error:
"Command text was not set for the command object. "

Session("aUpdateRows") is an array that contains Update statements (they are
there, there's no error with that)

This is how I have it written:
If Session("bUpdate") Then
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open Application("ConStr")
For nCtr = 0 to UBound(Session("aUpdateRows"),1)
oConn.Execute Session("aUpdateRows")(nCtr)
Next
oConn.Close
End If

Do you know why I get that error? Is there a better way to execute these
multiple updates?

Thanks!!
geniene

 

[Guest]

Nevermind, i got it! My ubound returned 1 too many so i have to do a " - 1"

For nCtr = 0 to UBound(Session("aUpdateRows"),1) - 1

Thanks!

 

[Jim Buyens]

Glad to be of assistance. (!)

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------