Re: [sqlite] statement is not executing

I think it has to do with the JDBC driver I'm using.. I updated to v053 of the sqlitejdbc driver and am still getting the error.. On Sun, Aug 31, 2008 at 5:27 PM, Greg Morphis <[EMAIL PROTECTED]> wrote: > I've got ColdFusion 8 connecting to my SQLite3 database.. > > When I run an insert using CFC

[sqlite] statement is not executing

I've got ColdFusion 8 connecting to my SQLite3 database.. When I run an insert using CFCs I get the error : Error Executing Database Query. statement is not executing What's odd is that the row gets inserted into the table... If I hit refresh in the browser I get the error that the Primary Key

Re: [sqlite] problem with update trigger

Okay, that indeed makes sense, I should have thought about it earlier. Thank you, Igor Igor Tandetnik schrieb: > > The UPDATE trigger isn't called once per statement, but once for each > row being updated. Since the WHERE clause in your statement doesn't > match any rows, no update takes plac