[CDBI] Re: mysql execute failed

k meehl <kmeehl-/[email protected]> Wed, 14 Mar 2007 15:55:13 -0700 (PDT)
Newsgroups gmane.comp.lang.perl.modules.class-dbi
Message-ID <[email protected]>
Hi Ed, thanks for the quick reply.

I've double checked my definitions and everything is
good. It looks from the error like an invalid query is
being sent to mysql. From the error message, the SQL
statemnt is

INSERT INTO table1 (testCol1, testCol3, testCol2)
VALUES (?, ?, ?)" with ParamValues: 1='testVal3',
0='testVal1', 2='testVal2'

I've never seen this ParamValues syntax before and
AFAICT it's not valid SQL. My guess is that this
intermediate syntax isn't being translated to SQL
properly, but why?



--- "Edward J. Sabol" <sabol-2oVx0MVsMgiP/[email protected]>
wrote:

> > I am at a complete loss as to where to look to
> resolve this error. If
> > anybody can help, or at least point me in a
> general direction, it would be
> > greatly appreciated.
> 
> The most likely place is in your testdb::table1
> module. My guess is that you
> have a syntax error your columns() definitions.
> 
> Hope this helps,
> Ed
> 



 
____________________________________________________________________________________
No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail