I'm working with MS-SQL 7 and IIS 4 as well as PHP4.0.4 ---
My question is that when a message is received while attempting to delete a
row in [table x] while it is tied to [table y.column a] by a foreign key
relationship [see below]
Warning: MS SQL message: DELETE statement conflicted with
, 2001 7:22 PM
To: [EMAIL PROTECTED]
Subject:[PHP-DB] MS-SQL Error Message Replacement
I'm working with MS-SQL 7 and IIS 4 as well as PHP4.0.4 ---
My question is that when a message is received while attempting to delete a
row in [table x] while it is tied to [table y.column
[EMAIL PROTECTED] wrote:
How can I put in my own custom message when these errors occur?
Should I be looking for a failed query message and then acting on
that? I like the protection that the foreign key relationship
enables, because you can't delete "parent" objects without
So you like to let the SQL check for those constraints and you want only the
PHP to deal with that ugly error:
- disable the error output by placing @ before your php-function
- catch the error either by checking $php_errormsg (works only if
error-tracking is enabled) or by the result code or