It's just a simple insert into table (columns) values (values).... <cffunction name="create" access="public" output="false" returntype="boolean">
<cfargument name="bill" required="true" type="Bills" hint="Bills bean" /> <cfset var qCreateBill = "" /> <cfquery name="qCreateBill" datasource="#variables.DSN#"> INSERT INTO BILLS ( PAYEEID, PAYEE, MINIMUMDUE, DUEDAY, ISCC, ISACTIVE, AMOUNTOWED, APR ) VALUES ( <cfqueryparam value="#arguments.bill.getPayeeID()#" cfsqltype="cf_sql_numeric" />, <cfqueryparam value="#arguments.bill.getPayee()#" cfsqltype="cf_sql_longvarchar" />, <cfqueryparam value="#arguments.bill.getMinimumDue()#" cfsqltype="cf_sql_numeric" />, <cfqueryparam value="#arguments.bill.getDueDay()#" cfsqltype="cf_sql_longvarchar" />, <cfqueryparam value="#arguments.bill.getIsCC()#" cfsqltype="cf_sql_numeric" />, <cfqueryparam value="#arguments.bill.getIsActive()#" cfsqltype="cf_sql_numeric" />, <cfqueryparam value="#arguments.bill.getAmountOwed()#" cfsqltype="cf_sql_numeric" />, <cfqueryparam value="#arguments.bill.getAPR()#" cfsqltype="cf_sql_numeric" /> ) </cfquery> <cfreturn true /> </cffunction> and the DB looks like.. CREATE TABLE bills ( payeeid integer primary key, payee TEXT, minimumdue numeric, apr numeric, amountowed real, iscc numeric DEFAULT 1, dueday TEXT, isactive numeric DEFAULT 1 ) On Mon, Sep 1, 2008 at 10:24 AM, P Kishor <[EMAIL PROTECTED]> wrote: > On 9/1/08, Greg Morphis <[EMAIL PROTECTED]> wrote: >> I understand this is a sqlite list, I had hoped that I wasnt the only >> one using it or trying to use it with ColdFusion.. >> I've also asked this on a CF list, just hoping somewhere out there is >> the answer.. > > No, no... don't get me wrong. There is no problem with describing the > tools you are using (CF and JDBC driver, in this case). However, you > have given no other context... no db schema, no example code, the > query you are executing, etc. There is little here for anyone to try > and help, other than if there happens to be another CF/SQLite/JDBC > user. > > Just offer more details, and you have a slightly better chance of > getting a meaningful reply. > >> >> Anyways, as I just posted the problem seems to be around the >> <cfqueryparam tag.. or at least that's part of it. >> >> I suppose since this is a local app, I don't need the <cfqueryparam >> tags, just looking for answers... >> >> Thanks >> >> >> >> On Mon, Sep 1, 2008 at 10:03 AM, P Kishor <[EMAIL PROTECTED]> wrote: >> > On 9/1/08, Greg Morphis <[EMAIL PROTECTED]> wrote: >> >> 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? >> >> >> >> >> > >> > >> > >> > Hi Greg, >> > >> > (a long time ago I used to use CF circa version 2 and 3). >> > >> > As you have yourself identified, the problem seems to be either with >> > your own queries, examples of which you have not provided in any of >> > your emails, or in the JDBC driver. Since neither CF nor the JDBC >> > driver are the focus of this list, you are unlikely to get much >> > response here... after all, this is a SQLite list, and SQLite seems to >> > be working fine. >> > >> > Perhaps if you were to provide example of your code, the query you are >> > doing, perhaps someone might be able to point out possible >> > logic/syntax errors, but other than that, you will likely get more >> > mileage from either CF list or from the provider of the JDBC driver. >> > >> > Fwiw, I have found that the JDBC driver does work fine, but most of my >> > queries have been rather simple via straight-ahead Java. >> > >> > >> > >> > -- >> > Puneet Kishor http://punkish.eidesis.org/ >> > Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ >> > Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ >> >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> > > > -- > Puneet Kishor http://punkish.eidesis.org/ > Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ > Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users