k == [EMAIL PROTECTED] writes: k> On Wed, 23 Mar 2005 15:11:13 -0600 (CST), Brandon Metcalf k> <[EMAIL PROTECTED]> wrote: k> > I have several cases where if I try to prepare() a statement and then k> > execute() it, I get the following: k> > k> > DBD::Pg::st execute failed: ERROR: column "report_time" is of type integer but expression is of type character varying k> > HINT: You will need to rewrite or cast the expression.
k> Well, I may regret saying this, but to me it sure sounds like a bug k> in your script :-( k> Do you by chance have ascii chars in your variable that Perpare is k> trying to set up (as an int)? Maybe a null value? k> Is the size of the variable value too large to fit in an int? k> Remember- Int's are pretty small - you might want to alter your schema k> to fit a long type. I would agree that there is a problem with my script if do() using the exact same data and SQL statement failed as well, but it doesn't. Having said that, I've printed out the values of the variables being passed to execute() and everything looks fine. I just wanted to check if this is a known issue before I troubleshoot this any further. -- Brandon
