I've been playing around with SQLite for a few days now.. It's pretty
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
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
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
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
>> few minutes.
> Ok, it works in 3.6.1 - sorry for the troubles... I'll just upgrade the
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 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
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?
when null, when '', when ' '...
Is there a nvl() function or something like Oracle has?
On Sat, Aug 30, 2008 at 5
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
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
On Sun, Aug 31, 2008 at 6:03 PM, Greg Morphis
>> at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
>> at coldfusion.sql.Executive.executeQuery(Executive.java:939)
>> On Sun, Aug 31, 2
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
I rebuilt the table as
CREATE TABLE bills
payeeid integer primary key,
iscc integer DEFAULT 1,
isactive integer DEFAULT 1
On Mon, Sep 1, 2008 at 10:46 AM, Greg Morphis <[EMAIL PROTECTED]> wrote:
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.
> On Mon, Sep 1, 2008 at 11:46 AM, Greg
Mail list logo