To further complicate things.. I removed all of the <cfqueryparam>s
and the code works.. I readd them and I get the same
Error Executing Database Query.
statement is not executing
The error occurred in
C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\testCF\cfc\myApp\appDAO.cfc:
line 92
The Stack Trace looks like :
java.sql.SQLException: statement is not executing
at org.sqlite.Stmt.checkOpen(Stmt.java:41)
at org.sqlite.PrepStmt.getUpdateCount(PrepStmt.java:86)
at
coldfusion.server.j2ee.sql.JRunStatement.getUpdateCount(JRunStatement.java:277)
at coldfusion.sql.Executive.getRowSet(Executive.java:513)
at coldfusion.sql.Executive.executeQuery(Executive.java:1205)
at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
at coldfusion.sql.Executive.executeQuery(Executive.java:939)
...
On Sun, Aug 31, 2008 at 6:03 PM, Greg Morphis <[EMAIL PROTECTED]> wrote:
> 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 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
>> must be unique..
>>
>> Anyone ever seen this?
>>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
