Interpreting error messages

WebHelper Joined: 30 Jul 2002 Posts: 56 Location: UK

When a DB returns an error, it may be that you want to catch it and take some action. For example, if an attempt was made to insert a non-unique value in a unique column. Is there a better way of interpreting the DB errors than just reading an error string, which will be server-specific and entirely possible to change between DB versions?

Hertzsprung

Team Member Joined: 06 Jan 2002 Posts: 2564

Well isn't that the kind of thing database abstraction layers do (info on them at http://www.4webhelp.net/tutorials/php/phplib_db.php )? If you put all your database code through a database abstraction layer, you shouldn't have to worry about errors, since this layer will deal with the errors on its own, regardless of the database type.

WebHelper Joined: 30 Jul 2002 Posts: 56 Location: UK

Daniel wrote:

Well isn't that the kind of thing database abstraction layers do (info on them at http://www.4webhelp.net/tutorials/php/phplib_db.php )? If you put all your database code through a database abstraction layer, you shouldn't have to worry about errors, since this layer will deal with the errors on its own, regardless of the database type.

That link is dead. And the reason why I wanted to know is because I'm writing my own abstraction layer! Smile

WebHelper Joined: 01 Mar 2003 Posts: 69 Location: Texas

Hertzsprung wrote:

That link is dead. And the reason why I wanted to know is because I'm writing my own abstraction layer! Smile

Just take off the closing )? that phpBB so thoughtfully added to the url for you, as in:

http://www.4webhelp.net/tutorials/php/phplib_db.php

Dave

Team Member Joined: 06 Jan 2002 Posts: 2564

Sorry about that. I've now edited my post.

WebHelper Joined: 30 Jul 2002 Posts: 56 Location: UK

I'm writing more of a DB + SQL abstraction Surprised