mssql_min_error_severity

Sets the lower error severity (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
void mssql_min_error_severity ( int severity )

Examples ( Source code ) » mssql_min_error_severity


<?php

// Connect to MSSQL

mssql_connect('navioo\SQLEXPRESS', 'sa', 'php4256sds');

mssql_select_db('php');


// Set the minimum error severity to not include SQL 

// syntax errors by setting it to something greater than 

// or equal to 1.

mssql_min_error_severity(1);


// Send a query we know that will cause an syntax error, in

// this case we use the MySQL quote signs instead of wrapping 

// square brackets around the field and table names.

$query = mssql_query('SELECT `syntax`, `error` FROM `MSSQL`');


if(!$query)

{

    // Custom error handler ...

}

?>

Code Examples / Notes » mssql_min_error_severity

daniel j. coleman

If you have not worked with MS SQL, severity is based on 5 levels. Level 0: The code contains a genuine error, and if executed, may not run as expected. For example, a syntax error or a reference to a non-existent method will cause a Level 0 error. Level 1: The code is syntactically correct, and has some defined meaning, but it may not be what the programmer was expecting. For example, a statement with no side effects such as x+1 will generate a Level 1 warning. Level 2: The code is correct but may cause problems in the future. For example, using deprecated features will generate a Level 2 warning. Level 3: The code is correct but may result in bad performance. For example, if type inferencing fails for a variable, a Level 3 warning will be issued. Level 4: The code is correct but there may be a better way to accomplish the same thing. For example, using a non-Common Language Specification (CLS) compliant method signature will generate a Level 4 warning.

Change Language

mssql_bind
mssql_close
mssql_connect
mssql_data_seek
mssql_execute
mssql_fetch_array
mssql_fetch_assoc
mssql_fetch_batch
mssql_fetch_field
mssql_fetch_object
mssql_fetch_row
mssql_field_length
mssql_field_name
mssql_field_seek
mssql_field_type
mssql_free_result
mssql_free_statement
mssql_get_last_message
mssql_guid_string
mssql_init
mssql_min_error_severity
mssql_min_message_severity
mssql_next_result
mssql_num_fields
mssql_num_rows
mssql_pconnect
mssql_query
mssql_result
mssql_rows_affected
mssql_select_db

mssql_min_error_severity

Sets the lower error severity (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4) void mssql_min_error_severity ( int severity )

Code Examples / Notes » mssql_min_error_severity

Change Language

Sets the lower error severity (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
void mssql_min_error_severity ( int severity )