[PHP-DB] MS-SQL Error Message Replacement

2001-01-24 Thread ryan . sinn
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

RE: [PHP-DB] MS-SQL Error Message Replacement

2001-01-24 Thread Alarion
, 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

Re: [PHP-DB] MS-SQL Error Message Replacement

2001-01-24 Thread Andreas Karajannis
[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

AW: [PHP-DB] MS-SQL Error Message Replacement

2001-01-24 Thread Matthias Kopolt
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