-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gilles Ganault wrote:
> I need to write an application to manage appointments. Most of them
> are recurrent, with no end-date, while others are one-shots, and the
> user must be able to schedule reccurent appointments but be able to
> tweak some
On Mon, Sep 1, 2008 at 10:29 PM, Derrell Lipman <
[EMAIL PROTECTED]> wrote:
>
>
> On Mon, Sep 1, 2008 at 10:16 PM, jonwood <[EMAIL PROTECTED]> wrote:
>
>>
>> Okay, I give up. I've been searching for a while now. I've found a number
>> of
>> discussions about how CURRENT_DATE returns the date in UT
On 9/1/08, jonwood <[EMAIL PROTECTED]> wrote:
>
>
> P Kishor-3 wrote:
> >
> > Don't think it is possible. As you noted, the docs say very clearly
> > (http://www.sqlite.org/lang_createtable.html) -- " The DEFAULT
> > constraint specifies a default value to use when doing an INSERT. ..
> > def
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> Background: Will 64 bit versions of SQLite buy us any significant
> difference in performance?
You need to have some benchmark code first, ideally in the form of a
representative script to feed to the sqlite shell. That way
P Kishor-3 wrote:
>
> Don't think it is possible. As you noted, the docs say very clearly
> (http://www.sqlite.org/lang_createtable.html) -- " The DEFAULT
> constraint specifies a default value to use when doing an INSERT. ..
> default value may also be one of the special case-independant keywor
Derrell Lipman wrote:
>
> I think this is the page you're looking for:
> http://www.sqlite.org/lang_datefunc.html
>
> In particular, a query that returns the current time in the local (to
> sqlite) time zone is:
>SELECT datetime('now', 'localtime');
> or for just the date:
>SELECT dat
On 9/1/08, jonwood <[EMAIL PROTECTED]> wrote:
>
> Okay, I give up. I've been searching for a while now. I've found a number of
> discussions about how CURRENT_DATE returns the date in UTC, and that it can
> be converted to local time. But I've yet to find one article that clearly
> states how o
On Mon, Sep 1, 2008 at 10:16 PM, jonwood <[EMAIL PROTECTED]> wrote:
>
> Okay, I give up. I've been searching for a while now. I've found a number
> of
> discussions about how CURRENT_DATE returns the date in UTC, and that it can
> be converted to local time. But I've yet to find one article that c
Okay, I give up. I've been searching for a while now. I've found a number of
discussions about how CURRENT_DATE returns the date in UTC, and that it can
be converted to local time. But I've yet to find one article that clearly
states how one might do this.
I would love to have a table column defa
Are there expected performance differences (better or worse) as a
result of the code factoring?
On Aug 30, 2008, at 8:01 PM, D. Richard Hipp wrote:
> SQLite version 3.6.2 is now available on the SQLite website:
> http://www.sqlite.org/download.html
>
> SQLite version 3.6.2 contains rewrites o
Myk Melez wrote:
> Unix times contain no time zone information (they are relative to an
> epoch in the UTC time zone), and SQLite's date/time functions return
> values in the UTC time zone by default:
argh, I should have thought of that. Thanks.
___
sq
Brandon Fosdick wrote:
> sqlite> select date('1220302462','unixepoch');
> 2008-09-01
> sqlite> select date('1220249914','unixepoch');
> 2008-09-01
>
Unix times contain no time zone information (they are relative to an
epoch in the UTC time zone), and SQLite's date/time functions return
valu
Using sqlite 3.4.0 (on both OS X 10.5.4 and iPhone 2.0.2) I'm seeing a
problem converting unix timestamps from today and yesterday.
In the sqlite console I get...
sqlite> select date('1220302462','unixepoch');
2008-09-01
sqlite> select date('1220249914','unixepoch');
2008-09-01
...however, the
[EMAIL PROTECTED] wrote:
> Does anyone have any benchmarks to share that compare common SQLite
> operations running under a 32 and 64 bit versions of SQLite? This
> question is OS neutral so please feel to share your experience with 32
> and 64 bit versions of Windows or Linux.
>
> Background: Will
On Mon, 01 Sep 2008 15:44:05 +0300, Mihai Limbasan
<[EMAIL PROTECTED]> wrote:
>You will need to loop through this.
Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, Sep 01, 2008 at 03:10:05PM -0400, [EMAIL PROTECTED] scratched on the
wall:
> Does anyone have any benchmarks to share that compare common SQLite
> operations running under a 32 and 64 bit versions of SQLite? This
> question is OS neutral so please feel to share your experience with 32
> an
I can't speak for SQLite, but off of the top of my head, a 64-bit platform
will give you enough virtual address space to memory map the files, which
usually proves to be a win. I'd say go with the 64-bit systems and as much
ram as you can afford.
- Sherief
> -Original Message-
> From: [EM
Does anyone have any benchmarks to share that compare common SQLite
operations running under a 32 and 64 bit versions of SQLite? This
question is OS neutral so please feel to share your experience with 32
and 64 bit versions of Windows or Linux.
Background: Will 64 bit versions of SQLite buy us an
I don't want to upset anyone here either since SQLite is a great database
but since you work with CF8 and so do I, I think its safe to say SQLite is
not the answer for you here. Derby offers a lot but why I suggested it is
because it comes out of the box with CF8. You will have more pain setting up
Honestly, for S&G mainly.. I have been using Postgres and I don't need
that kind of power or resources tied up for a simple app.
I suppose I could use MySQL but it's a simple DB.. I like using SQLite
and would love to get this to work..
I'll look into Apache Derby.. I know nothing of it however
O
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:
> It's j
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
It's just a simple insert into table (columns) values (values)
INSERT INTO
BILLS
(
PAYEEID,
PAYEE,
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. Th
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..
Anyways, as I just posted the problem seems to be around the
wrote:
> On 9/1/08, Greg Morphis
On 9/1/08, Greg Morphis <[EMAIL PROTECTED]> wrote:
> To further complicate things.. I removed all of the 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-ea
To further complicate things.. I removed all of the 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
Gilles Ganault wrote:
Hello
I need to write an application to manage appointments. Most of them
are recurrent, with no end-date, while others are one-shots, and the
user must be able to schedule reccurent appointments but be able to
tweak some of them if need be.
To investigate whether
Hello
I need to write an application to manage appointments. Most of them
are recurrent, with no end-date, while others are one-shots, and the
user must be able to schedule reccurent appointments but be able to
tweak some of them if need be.
To investigate whether I need to bother keeping
29 matches
Mail list logo
