Re: DBD::SQLite will connect and CREATE, but not INSERT...sort of

Considering you're getting a syntax error and not using $dbh->quote to quote what you're inserting I'd wager the problem is that you're, well, not giving SQLite valid SQL to execute. Print out $sql before you try and execute it (which should always be the first step you take to diagnose misbehaving DBI problems (well, that and/or turning on tracing on the handle)).

Comment on Re: DBD::SQLite will connect and CREATE, but not INSERT...sort of Select or Download Code

Replies are listed 'Best First'.
Re^2: DBD::SQLite will connect and CREATE, but not INSERT...sort of by EvanK (Chaplain) on Apr 23, 2007 at 21:14 UTC
I am using `$dbh->quote`, I just didnt include the code for it (I instead noted that it was being quoted)...Ironically, I grabbed the newest source tarball for said module and compiled it from scratch and curiously...it worked. I'll consider that my "shooting oneself in the foot" moment of the day, since that should have been the first damn thing i tried. Sorry, feel free to throw rocks now :o __________ Systems development is like banging your head against a wall... It's usually very painful, but if you're persistent, you'll get through it.	[reply] [d/l]
Re^3: DBD::SQLite will connect and CREATE, but not INSERT...sort of by wjw (Priest) on Apr 24, 2007 at 03:18 UTC
Don't you love it when that happens? I bet I shoot myself in the foot 3 times a day on a bad day... I keep shooting and I will be walking on stumps soon... . Glad it worked out. :-) ...the majority is always wrong, and always the last to know about it...	[reply]