Using Command Objects

Results 1 to 2 of 2

Thread: Using Command Objects

  1. #1
    Brian Frankle Guest

    Default Using Command Objects

    I am using a command object (ADODB.Command) to issue and Insert to a table. I build my insert sql and then issue and Execute on the command object. Is there a way to get the sql return code from the execute and perform my own processing if the sql fails.<BR>Ie. a Rollback.<BR><BR>Thanks,<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Using Command Objects

    Check the err object, it&#039;s 0 if it was successful. err.Num? or is it err.Number. I think Name is another property of that object.<BR><BR>You can always response.write it and see it&#039;s value.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts