[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