Have you tried writing a wrapper function for mssql_query(), something like:
my_mssql_query( $query, $link_id){
         global $php_errormsg;
         ob_start();
         $result = mssql_query( $query, $link_id );
         if( !$result ){
                 $php_errormsg = ob_get_contents();
         }
         ob_end_clean();

         return $result;
}

morgan

At 09:48 AM 3/30/2001, Christian Dechery wrote:
>isn't there a better way to handle MS SQL error messages? I can't even 
>fetch them...
>look at these warnings... they only show in development side, I don't want 
>warnings on the production site, so I turn them off with error_reporting()...
>
>Warning: MS SQL message: There is already an object named 'FK_genre_genre' 
>in the database. (severity 16) in 
>S:\Inetpub\wwwroot\liquid\liquid_catalog_update.php on line 607
>
>Warning: MS SQL message: Could not create constraint. See previous errors. 
>(severity 16) in S:\Inetpub\wwwroot\liquid\liquid_catalog_update.php on 
>line 607
>
>Warning: MS SQL: Query failed in 
>S:\Inetpub\wwwroot\liquid\liquid_catalog_update.php on line 607
>
>Could not create constraint. See previous errors. <-- this is what I get 
>from mssql_get_last_message()
>MS SQL: Query failed <-- this is the content of $php_errormsg
>
>you guys have to agree with me, that neither of them help me at all....
>why can't I fetch the first Warning, the one with the really interesting 
>content???

Reply via email to