Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
en 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

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
I rebuilt the table as CREATE TABLE bills ( payeeid integer primary key, payee TEXT, minimumdue float, apr float, amountowed float, iscc integer DEFAULT 1, dueday TEXT, isactive integer DEFAULT 1 ) On Mon, Sep 1, 2008 at 10:46 AM, Greg Morphis <[EMAIL PROTECTED]> wrote:

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
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 ColdF

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
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, 2

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
) 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

Re: [sqlite] statement is not executing

2008-08-31 Thread Greg Morphis
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

[sqlite] statement is not executing

2008-08-31 Thread Greg Morphis
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] help with SQL

2008-08-30 Thread Greg Morphis
by amountowed, b.apr, b.dueday, b.minimumdue, b.payee, b.payeeid, p2.amount, p2.paiddate,p2.payments, b.iscc, b.isactive What is p2.payments if the count(*) was null? I've tried when null, when '', when ' '... Is there a nvl() function or something like Oracle has? Thanks On Sat, Aug 30, 2008 at 5

[sqlite] help with SQL

2008-08-30 Thread Greg Morphis
I have this SQL in Postgres and it works fine, I'm trying to port it over to SQLite and having issues.. SQLite doesnt like left outer joining to a subquery.. Can you guys think of a way around this? select b.amountowed, b.apr, b.dueday, b.minimumdue, b.payee, p.note, b.payeeid, case when p.amount

Re: [sqlite] 2 Questions from a newbie

2008-08-19 Thread Greg Morphis
Also why are you adding new columns? doesn't sound like you have the db set up properly.. On Tue, Aug 19, 2008 at 11:53 AM, cstrader <[EMAIL PROTECTED]> wrote: > OK, cool idea... let me try that. > > > - Original Message - > From: "Jeff Hamilton" <[EMAIL PROTECTED]> > To: <[EMAIL

Re: [sqlite] SQL statement to get min/max values

2008-08-14 Thread Greg Morphis
I've got 3.6.0 and it works fine here On Thu, Aug 14, 2008 at 9:09 PM, Dennis Volodomanov <[EMAIL PROTECTED]> wrote: >> I'm using 3.3.5, I'll get the latest and see if works there or not in > a >> few minutes. > > Ok, it works in 3.6.1 - sorry for the troubles... I'll just upgrade the > program

Re: [sqlite] SQL statement to get min/max values

2008-08-14 Thread Greg Morphis
Could it be that since you're not defining a type for Data it assumes string? Try creating the table with id integer, externalid integer, data number (or numeric) On Thu, Aug 14, 2008 at 7:00 PM, Dennis Volodomanov <[EMAIL PROTECTED]> wrote: > Hello all, > > I've tried a few SQL statements, but

Re: [sqlite] Ignoring "The"

2008-07-23 Thread Greg Morphis
Could you do something like select title from foo order by replace(title, 'The ', ''); ?? Or add a order_by column On Wed, Jul 23, 2008 at 8:49 AM, Sherief N. Farouk <[EMAIL PROTECTED]> wrote: > Can you define a custom less-than operator for sorting? If this were C++, > I'd do

[sqlite] hello, new to list

2008-07-21 Thread Greg Morphis
I've been playing around with SQLite for a few days now.. It's pretty impressive. I was curious if there were any plans to support right outer joins and full outer joins? I was hoping to utilize SQLite for a couple home projects I have created in Postgres. I don't think I need a huge horse like