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 Pos
sqlite3 test.db works, what error are you getting?
and to exit (on a windows system Ctrl + C works
On Tue, Jul 22, 2008 at 9:01 AM, Milton Centeno <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed
> in the getting started guide on the
yeah, if you just enter sqlite3 then it creates an in-memory database,
to create a working and existing database, enter "sqlite3 test.db" at
the C:\ prompt. Example "C:\> sqlite3 test.db"
Ignore my comment on the Ctrl + C, if you're seeing the ---> then it's
waiting for a semi-colon ";".
Thanks
>
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 std::sort(Result.beg
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 ca
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 th
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 PROTECTED
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
where isactive = 0
group 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 li
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..
>
> W
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
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
ctive 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 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:
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
>
16 matches
Mail list logo