SID-00973: Trap database errors

Status:	Answered	TWiki version:	4.3.1	Perl version:	5.10
Category:	DBIQueryPlugin	Server OS:	Windows Vista	Last update:	15 years ago

I have DATABASE_SQL statements which does insert/delete/update. I am not able to trap if the sql returns an error. How do I trap the error that is being returned?

-- TWikiGuest - 2010-09-21

Discussion and Answer

The DBIQueryPlugin needs to be enhanced. Could be done with a new showerror="" parameter. Proposed spec:

• showerror="yes" - show errors (default)
• showerror="no" - do not show errors

TWiki is open source. You could sponsor the work. Or if you are a programmer, you could enhance the plugin and post a patch to the DBIQueryPluginDev page.

See related SID-00972.

-- PeterThoeny - 2010-09-21

The situation here is a bit different from SID-00972. Here instead of suppessing the error, I want to trap it and act accordingly...

-- TWikiGuest - 2010-09-27

Yes, I am aware of that.

Interested in sponsoring the work? I can look for a consultant for you.

-- PeterThoeny - 2010-09-27

Yes, would like to hire a consultant. What is the rate I am looking at?

-- TWikiGuest - 2010-09-28

Please contact me by e-mail.

-- PeterThoeny - 2010-09-28

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.