Greg,

I'm sorry to hear about the troubles you are running into. I've been using
SQLite since I've been doing AIR development although my real bread and
butter is CF development. I've never seen anyone connect CF8 and SQLite and
am wondering why you have chosen that? The reason I ask is CF8 comes with
Derby embedded and I would think that would be the best answer for you.
Sorry I can't help any further.

Ciao!
Javi

On Mon, Sep 1, 2008 at 11:46 AM, Greg Morphis <[EMAIL PROTECTED]> wrote:

> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to