Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mssql_min_error_severity(3) [php man page]

MSSQL_MIN_ERROR_SEVERITY(3)											       MSSQL_MIN_ERROR_SEVERITY(3)

mssql_min_error_severity - Sets the minimum error severity

SYNOPSIS
void mssql_min_error_severity (int $severity) DESCRIPTION
Sets the minimum error severity. PARAMETERS
o $severity - The new error severity. RETURN VALUES
No value is returned. EXAMPLES
Example #1 mssql_min_error_severity(3) example <?php // Connect to MSSQL and select the database mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi'); 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 ... } ?> PHP Documentation Group MSSQL_MIN_ERROR_SEVERITY(3)

Check Out this Related Man Page

MSSQL_FIELD_LENGTH(3)													     MSSQL_FIELD_LENGTH(3)

mssql_field_length - Get the length of a field

SYNOPSIS
int mssql_field_length (resource $result, [int $offset = -1]) DESCRIPTION
Returns the length of field no. $offset in $result. PARAMETERS
o $result - The result resource that is being evaluated. This result comes from a call to mssql_query(3). o $offset - The field offset, starts at 0. If omitted, the current field is used. RETURN VALUES
The length of the specified field index on success or FALSE on failure. EXAMPLES
Example #1 mssql_field_length(3) example <?php // Connect to MSSQL and select the database mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi'); mssql_select_db('php'); // Send a select query to MSSQL $query = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]'); // Print the field length echo 'The field 'age' has a data length of ' . mssql_field_length($query, 1); // Free the query result mssql_free_result($query); ?> The above example will output something similar to: The field 'age' has a data length of 4 NOTES
Note Note to Windows Users Due to a limitation in the underlying API used by PHP (MS DBLib C API), the length of VARCHAR fields is limited to 255. If you need to store more data, use a TEXT field instead. SEE ALSO
mssql_field_name(3), mssql_field_type(3). PHP Documentation Group MSSQL_FIELD_LENGTH(3)
Man Page