Oops! Sorry all, wrong db. At 05:05 PM 7/24/2002 -0700, Doug Durham wrote: >$result=mssql_query($sql2)or die("sql2 failed<br>" . mysql_errno() . ": " >. mysql_error()); > >At 04:48 PM 7/24/2002 -0700, Salve Tinkerworth wrote: >>Does anyone have any good tips for error handling? I've tried different >>methods to retrieve good error information from mssql_query but nothing >>seems to be working. >> >>Here's the latest attempt: >> >>$result=mssql_query($sql2); >>$result=mssql_query('SELECT @@ERROR As ErrorCode'); >>$error=mssql_fetch_row($result); >>if($error['ErrorCode'] != 0) { >> echo $error['ErrorCode']; >> echo $sql2; >> die('Inserting OPS failed'); >>} >> >> >> >>-- >>PHP Database Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > >
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php