| pgsql and exception [message #178100] |
Mon, 14 May 2012 06:39  |
Une Bvue
Messages: 30
Registered: March 2012
Karma:
|
Member |
|
|
I have an INSERT generating an exception :
ERROR: value too long for type character varying(30)
this error comes from try out usinf command line.
I'd like to print-out this error when using this database from php.
Then, i did :
$ret=$db->query($sql);
try {
while($row=$ret->fetch()){ // line 492
$rowid=$row['rowid'];
}
// do something
} catch (Exception $e) {
echo $e->getMessage()."<br />\n";
}
or using :
} catch (PDOException $e) {
echo $e->getMessage()."<br />\n";
}
From php i get :
Fatal error: Call to a member function fetch() on a non-object in
/Users/yt/Sites/landp_public/landp.php on line 492
line 492 being "while($row=$ret->fetch()){"
obviously the best way is to avoid having a varchar column with a length
lower than 30.
could i get the error from $ret ?
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]