Re: [sqlite] Search results

Greg, "Greg Obleshchuk" <[EMAIL PROTECTED]> 26/03/2004 03:29 PM To: <[EMAIL PROTECTED]> cc: Subject:[sqlite] Search results > In the database I will have three columns where I will be searching for matches , my question is what type of method do

Re: [sqlite] ENUM semantics

At 12:05 AM -0500 3/26/04, Rich Coco wrote: I looked into triggers, but the SQLite implementation did not seem to have the flexibility I needed to implement ENUM. btw - i am not a DB guy at all (tho maybe that will change soon!), so my 'DB/SQL intuitio' is still embryonic. By your suggestion to

[sqlite] Search results

Hi Everyone, This is a tiny bit off subject, so sorry. I have a search page on my web site which when used will search the database for results. I want to be able to rank the results in best match first order. In the database I will have three columns where I will be searching for matches , my

Re: [sqlite] ENUM semantics

At 11:22 PM -0500 3/25/04, Rich Coco wrote: darren - thanks for the response. is this an use for a User Defined Function? Or do I misunderstand the intended uses of UDFs. tx, - rich My understanding is that User Defined Functions are something completely separate. User defined functions allow

Fw: [sqlite] TWS for Windows - link

> It works !!! on Win2000 !!! > > WishList: I would certainly like to see an example database application > using SQLite. (maybe its there, but I couldnt find any obvious code). I > want to scrap IIS & Sambar & Apache efforts for something far more simple, > like TWS. > > > - Original Message

Re: [sqlite] Difference between Transaction Journal and Checkpoint Journal

Thursday, March 25, 2004, 1:33:03 AM, Rohit wrote: > I was going thru the pager source code ( pager.c ). The comments include > references to "Journal", "Transaction Journal", "Checkpoint Journal". What > is the difference between the three? Am I missing something? There is only one journal

RE: [sqlite] Change value on a trigger

There is an entire section in the SQL language specification dedicated to triggers, if you need further help just come and ask. http://www.sqlite.org/lang.html Regards, PeterP. -Original Message- From: António Vieira (DSI) [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004

[sqlite] CREATE TABLE on conflict ignore?

Hi SQLiters! Can someone tell me the proper syntax for CREATE TABLE and if theres a conflict ignore it. I've tried several versions of the CREATE TABLE query. All I get is an error that the table already exists. Thats what I'm trying to avoid. I've tried using BEGIN ON CONFLICT IGNORE and

[sqlite] Change value on a trigger

In sqlite it's possible to change the value inserted or updated inside a trigger? Something like this: CREATE TABLE foo (a); BEFORE INSERT ON foo BEGIN NEW.a=1; END; Thanks.