surpress output to screen

[alanl1]

Hi Profesionals hope i can make sense on this one.

 

I am calling a sp_rename procedure in sqlserver with my php page and it is showing the error on the screen

 

 

Array ( [0] => Array ( [0] => 01000 [SQLSTATE] => 01000 [1] => 15477 [code] => 15477 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Caution: Changing any part of an object name could break scripts and stored procedures. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Caution: Changing any part of an object name could break scripts and stored procedures. ) )

 

 

is there a way to surpress this in php or refresh the screen or jump to another page or something as it is very annoying.

 

apparently it is a compilation error in sqlserver during the renaming of columns which cannot be removed from a database end.

 

thanks

[requinix]

PHP will not output it for you - there is code somewhere that is doing this. It's specifically using print_r(), if you want something to search for.

So... make it not do that.

[mac_gyver]

slightly different slant on the problem - the error reporting logic in your code should log that information when on a live server, rather than outputting it to the visitor. an easy way of controlling what is logged or displayed is to use trigger_error() as that will let you use php's display_errors/log_errors settings to control where your error reporting logic sends the output.