Hear Howard DeYoung- Director of Information Technology for City of St. Cloud describe the experience of innovating cyberspots in his city with the HPBladeSystem solutions
A Tribute to India
For our Indian members, please let us know in the poll what city you live (or work)?
Mumbai (Bombay)
Delhi
Kolkata (Calcutta)
Chennai (Madras)
Bangalore
Hyderabad
Pune
Ahmedabad
Kanpur
Surat
Other (Please Tell Us in Post and Write in Poll, Thanks!)
Don't Live in... (32 Replies)
Tim Bass
Thu, 15 Nov 2007 23:55:07 +0000
*I predict we may experience less*debates*on the use of the term “event cloud”*related to*CEP in the future, now that both IBM and Google* have made announcements about “cloud computing” and “computing cloud”, IBM Turning Data Centers Into ‘Computing... (0 Replies)
MAXDB_SQLSTATE(3) 1 MAXDB_SQLSTATE(3)maxdb_sqlstate - Returns the SQLSTATE error from previous MaxDB operation
Procedural style
SYNOPSIS
string maxdb_sqlstate (resource $link)
DESCRIPTION
Object oriented style
string$maxdb->sqlstate ()
Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. '00000' means no
error. The values are specified by ANSI SQL and ODBC.
Note
Note that not all MaxDB errors are yet mapped to SQLSTATE's. The value HY000 (general error) is used for unmapped errors.
RETURN VALUES
Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. '00000' means no
error.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
/* Table City already exists, so we should get an error */
if (!$maxdb->query("CREATE TABLE hotel.city (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.
", $maxdb->sqlstate);
}
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
/* Table City already exists, so we should get an error */
if (!maxdb_query($link, "CREATE TABLE hotel.city (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.
", maxdb_sqlstate($link));
}
maxdb_close($link);
?>
The above example will output something similar to:
Warning: maxdb_query(): -6000POS(20) Duplicate table name:CITY [I6000] <...>
Error - SQLSTATE I6000.
SEE ALSO maxdb_errno(3), maxdb_error(3).
PHP Documentation Group MAXDB_SQLSTATE(3)