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.
mssql_min_error_severity
(PHP 4, PHP 5, PECL odbtp >= 1.1.1)
mssql_min_error_severity — Fija el nivel mínimo de severidad de los errores
Descripción
void mssql_min_error_severity
( int
$severity
)Fija el nivel mínimo de severidad de los errores.
Parámetros
-
severity -
La nueva severidad de los errores.
Valores devueltos
No devuelve ningún valor.
Ejemplos
Ejemplo #1 Ejemplo de mssql_min_error_severity()
<?php
// Conectar a MSSQL y seleccionar la base de datos
mssql_connect('KALLESPC\SQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php');
// Fija el nivel mínimo de severidad a partir de la cual se han de mostrar
// errores de sintaxis SQL dándole el valor mayor o igual
// a uno.
mssql_min_error_severity(1);
// Enviar una consulta que sabemos que generará un error, en
// este caso lo provocamos usando las comillas simples en lugar de
// poner corchetes alrededor del nombre de campo y de la tabla.
$query = mssql_query('SELECT `syntax`, `error` FROM `MSSQL`');
if (!$query) {
// Gestión personalizada del error ...
}
?>
Daniel J. Coleman ¶
9 years ago
