Re: [sqlite] Creating recurrent appointments?

2008-09-01 Thread Roger Binns
-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

Re: [sqlite] Default Column Value to Local Time

2008-09-01 Thread Derrell Lipman
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

Re: [sqlite] Default Column Value to Local Time

2008-09-01 Thread P Kishor
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. .. > >

Re: [sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread Roger Binns
-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

Re: [sqlite] Default Column Value to Local Time

2008-09-01 Thread jonwood
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

Re: [sqlite] Default Column Value to Local Time

2008-09-01 Thread jonwood
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

Re: [sqlite] Default Column Value to Local Time

2008-09-01 Thread P Kishor
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

Re: [sqlite] Default Column Value to Local Time

2008-09-01 Thread Derrell Lipman
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

[sqlite] Default Column Value to Local Time

2008-09-01 Thread jonwood
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

Re: [sqlite] SQLite version 3.6.2

2008-09-01 Thread Russell Leighton
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

Re: [sqlite] Bug in conversion from unixepoch

2008-09-01 Thread Brandon Fosdick
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. ___

Re: [sqlite] Bug in conversion from unixepoch

2008-09-01 Thread Myk Melez
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

[sqlite] Bug in conversion from unixepoch

2008-09-01 Thread Brandon Fosdick
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

Re: [sqlite] Difference in performance between 32 and 64 bit versionsof SQLite?

2008-09-01 Thread John Elrick
[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:

Re: [sqlite] Creating recurrent appointments?

2008-09-01 Thread Gilles Ganault
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

Re: [sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread Jay A. Kreibich
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 >

Re: [sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread Sherief N. Farouk
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:

[sqlite] Difference in performance between 32 and 64 bit versions of SQLite?

2008-09-01 Thread python
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

Re: [sqlite] statement is not executing

2008-09-01 Thread Javier Julio
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

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
Honestly, for S 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 On

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: > It's

Re: [sqlite] statement is not executing

2008-09-01 Thread Javier Julio
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

Re: [sqlite] statement is not executing

2008-09-01 Thread Greg Morphis
It's just a simple insert into table (columns) values (values) INSERT INTO BILLS ( PAYEEID, PAYEE,

Re: [sqlite] statement is not executing

2008-09-01 Thread P Kishor
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.

Re: [sqlite] statement is not executing

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

Re: [sqlite] statement is not executing

2008-09-01 Thread P Kishor
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 >

Re: [sqlite] statement is not executing

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

Re: [sqlite] Creating recurrent appointments?

2008-09-01 Thread Mihai Limbasan
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

[sqlite] Creating recurrent appointments?

2008-09-01 Thread Gilles Ganault
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