[thelist] Command text was not set for the command object.

darren darren at web-bitch.co.uk
Fri Nov 30 08:27:55 CST 2001


On 30 November 2001 at 14:18:32, Paul Backhouse <paul.backhouse at 2cs.com> wrote:

<snip
PB>         Set objRS = objConn.Execute(strQuery)

try:
   set objRS = objConn.Execute(strQuery, , adCmdText)

you can put a variable as the second parameter to get the number of
records affected by the query...if you're doing an update or delete
for example.

hth,

darren





More information about the thelist mailing list