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:
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
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
)
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
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
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
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
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
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
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
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
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
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
13 matches
Mail list logo