FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » pgsql and exception
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
pgsql and exception [message #178100] Mon, 14 May 2012 06:39 Go to previous message
Une Bvue is currently offline  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 ?
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:
Next Topic: Re: reading a newline from a properties file
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 09 08:49:31 GMT 2024

Total time taken to generate the page: 0.05040 seconds