Re: [sqlite] datetime modifier for localtime

2004-01-16 Thread Derrell . Lipman
Kurt Welgehausen <[EMAIL PROTECTED]> writes: > If I remember right, localtime and gmtime were not implemented > in 2.8.8. You need to upgrade. Ah! Well that would certainly explain it. Thanks! Derrell - To unsubscribe,

RE: [sqlite] Full text search implementation

2004-01-16 Thread Steve O'Hara
> -Original Message- > From: Bertrand Mansion [mailto:[EMAIL PROTECTED] > Sent: 16 January 2004 19:18 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [sqlite] Full text search implementation > > > <[EMAIL PROTECTED]> wrote : > > > > > > >> -Original Message- > >> From:

[sqlite] datetime modifier for localtime

2004-01-16 Thread Derrell . Lipman
end_time contains an integer value returned by the C function time(NULL), thus a value in the "unixepoch" format. How do I retrieve the pretty-printed value of the localtime? As can be seen from the statements below, I can retrieve the 'unixepoch' datetime value but not a value converted to

Re: [sqlite] Full text search implementation

2004-01-16 Thread Bertrand Mansion
<[EMAIL PROTECTED]> wrote : > > >> -Original Message- >> From: David Morel [mailto:[EMAIL PROTECTED] >> Sent: 16 January 2004 17:32 >> To: Brad Campbell >> Cc: George Ionescu; [EMAIL PROTECTED] >> Subject: Re: [sqlite] Full text search implementation >> >> >>> My regex patch should do

RE: [sqlite] Full text search implementation

2004-01-16 Thread Steve O'Hara
> -Original Message- > From: David Morel [mailto:[EMAIL PROTECTED] > Sent: 16 January 2004 17:32 > To: Brad Campbell > Cc: George Ionescu; [EMAIL PROTECTED] > Subject: Re: [sqlite] Full text search implementation > > > > My regex patch should do that > > > > SELECT * FROM Categories

Re: [sqlite] Full text search implementation

2004-01-16 Thread Brad Campbell
David Morel wrote: My regex patch should do that SELECT * FROM Categories WHERE CategoryDescription RLIKE 'Beverages" and CategoryDescription NOT RLIKE 'Whiskey'; In such a simple string matching I suspect a regex search is totally overkill... that's ok for a db containing 1000 rows, but try

Re: [sqlite] Full text search implementation

2004-01-16 Thread David Morel
> My regex patch should do that > > SELECT * FROM Categories WHERE CategoryDescription RLIKE 'Beverages" and > CategoryDescription NOT > RLIKE 'Whiskey'; > In such a simple string matching I suspect a regex search is totally overkill... that's ok for a db containing 1000 rows, but try it on

Re: [sqlite] Full text search implementation

2004-01-16 Thread David Morel
Le ven 16/01/2004 à 15:30, George Ionescu a écrit : > I've been using sqlite for quite some time now and I am a fan (thank you Dr. > Hipp). so am I > Regarding Full Text Search syntax, I think CONTAINS statement would be ok > (as implemented in other database engines). > So: > SELECT * FROM

Re: [sqlite] Full text search implementation

2004-01-16 Thread Brad Campbell
George Ionescu wrote: Hello dear SQLite users. Hello Dr. Hipp, I've been using sqlite for quite some time now and I am a fan (thank you Dr. Hipp). I will try to rewrite my (unfinished) Document Management application using SQLite and I was wondering if Full Text Search will be implemented. I'vee

Re: [sqlite] SQLite Browser (Mac OS 10.3)

2004-01-16 Thread Will Leshner
On Jan 16, 2004, at 7:31 AM, Wade Preston Shearer wrote: Ah... very effective post. Any idea which log I should view? Yes, I wanted to add that info, but I'm not sure myself. I want to say "system.log" but I'm not sure. When I think when I add debugging code to sqlite myself, that's where it

Re: [sqlite] SQLite Browser (Mac OS 10.3)

2004-01-16 Thread Wade Preston Shearer
I understand the difference between the two and use them both often, for their intended purposes. Yes, it was Console that I had open each time I was launching SQLite Browser and attempting to monitor for errors... and each time Console showed nothing. I have tried this on multiple computers

Re: [sqlite] SQLite Browser (Mac OS 10.3)

2004-01-16 Thread Will Leshner
On Jan 16, 2004, at 7:15 AM, Wade Preston Shearer wrote: I understand the difference between the two and use them both often, for their intended purposes. Yes, it was Console that I had open each time I was launching SQLite Browser and attempting to monitor for errors... and each time Console

Re: [sqlite] SQLite Browser (Mac OS 10.3)

2004-01-16 Thread Wade Preston Shearer
Yes... in OS X, everything that happens is written on in an app called Console. I write the author a while back too and he asked that I attempt to launch it again with Console running and then send him whatever errors/messages appear, but... strangely... I am still getting nothing in the

Re: [sqlite] SQLite Browser (Mac OS 10.3)

2004-01-16 Thread Mauricio Piacentini
Yes... in OS X, everything that happens is written on in an app called Console. I write the author a while back too and he asked that I attempt to launch it again with Console running and then send him whatever errors/messages appear, but... strangely... I am still getting nothing in the

[sqlite] Full text search implementation

2004-01-16 Thread George Ionescu
Hello dear SQLite users. Hello Dr. Hipp, I've been using sqlite for quite some time now and I am a fan (thank you Dr. Hipp). I will try to rewrite my (unfinished) Document Management application using SQLite and I was wondering if Full Text Search will be implemented. I'vee seen a ticket posted