Handling errors when updating records ADO/ASP

Results 1 to 3 of 3

Thread: Handling errors when updating records ADO/ASP

  1. #1
    Pier Guest

    Default Handling errors when updating records ADO/ASP

    I&#039;m trying to handle errors on an asp page that is supposed to insert or update records into an sql database with ADO.<BR><BR>I have followed the article of 4guysfromrolla about handling errors but the &#039;on error resume next&#039; simply don&#039;t work.<BR><BR>When I receive any kind of error (string too long, bad format of date, string into numeric) I keep receiving an error message and the application stops without resuming.<BR><BR>I&#039;ve read somewhere that &#039;on error resume next&#039; does not work when updating or inserting... so, does anyone knows what can I do for handling these kind of errors when updating or inserting new rows with ado?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default Post your code...

    ...I use on error resume next as part of my error trapping all the time.

  3. #3
    Pier Guest

    Default RE: Post your code...

    I use it as well, but when I try to insert or update with ado and the data to be inserted into the database does not fit with the column definition (length per example) the aplication stops and shows the parser error code for that... even if I have used on error move next.<BR><BR>Thanks anyway

Posting Permissions

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