Re: [sqlite] fts2 (full-text search v2) checked into CVS.

2006-10-12 Thread Cesar David Rodas Maldonado
That's very cool... What i am wondering is if is there any way to download the complete tarball of that folder... thanks. On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote: I've checked a new version of the full-text search module into ext/fts2 under CVS. fts2 uses a very different style of

[sqlite] Escaping wildcards when using LIKE & UTF-16

2006-10-12 Thread Vitali Lovich
I have a statement along the lines of: "SELECT * FROM table WHERE value LIKE :abc" I want to bind a UTF-16 string to abc - however, it can potentially contain % or _ - does sqlite provide any functionality for escaping these characters (I know I have to use the escape clause, but I still have

[sqlite] fts2 (full-text search v2) checked into CVS.

2006-10-12 Thread Scott Hess
I've checked a new version of the full-text search module into ext/fts2 under CVS. fts2 uses a very different style of storage from fts1, and is much much faster for insertions (25x faster inserting the Enron email database, for instance). The interface is identical, you just refer to fts2

Re: [sqlite] insert using underscore as literal

2006-10-12 Thread Dennis Cote
incoronado wrote: I'm trying to insert text data that includes an underscore. SQLite is removing the underscore. Is there any way to escape the underscore? It works for me without any special escaping. sqlite> create table t(a text); sqlite> insert into t values ('_'); sqlite>

Re: [sqlite] Helloo...

2006-10-12 Thread Cesar David Rodas Maldonado
Thanks Nuyt. I will implement. On 10/12/06, Kees Nuyt <[EMAIL PROTECTED]> wrote: On Thu, 12 Oct 2006 15:24:22 -0400, you wrote: > PD: I think it could be implement in SQLite to but > I dont know if it support UNION in selects... It does. http://www.sqlite.org/lang_select.html -- ( Kees

Re: [sqlite] Helloo...

2006-10-12 Thread Kees Nuyt
On Thu, 12 Oct 2006 15:24:22 -0400, you wrote: > PD: I think it could be implement in SQLite to but > I dont know if it support UNION in selects... It does. http://www.sqlite.org/lang_select.html -- ( Kees Nuyt ) c[_]

[sqlite] Helloo...

2006-10-12 Thread Cesar David Rodas Maldonado
Hello, I just would like to let you know about this page that I think it is of your interest. Class: guaranix Rank http://cesars.users.phpclasses.org/grank Regards Cesar Rodas PD: I think it could be implement in SQLite to but I dont know if it support UNION in selects...

Re: [sqlite] new sqlite-based webserver

2006-10-12 Thread Raymond Irving
Very nice indeed. Any chance we will see some kind of SourceFourge opening soon? Maybe after adding docs and multithreading capabilities? __ Raymond Irving --- Günter Greschenz <[EMAIL PROTECTED]> wrote: > hi raymond, > > your idea of including other files is already done. > there is a

Re: [sqlite] Select ignoring accents

2006-10-12 Thread Dennis Cote
Marco Bambini wrote: I need to find out a way to search all the records inside an sqlite database ignoring accents and case. So for example with a "select" I would like to find: Aero àero Aéro Ignoring case is the easy part, what about accents? Marco, You will need to create your own

[sqlite] Select ignoring accents

2006-10-12 Thread Marco Bambini
I need to find out a way to search all the records inside an sqlite database ignoring accents and case. So for example with a "select" I would like to find: Aero àero Aéro Ignoring case is the easy part, what about accents? Thanks a lot for your help. --- Marco Bambini

Re[2]: [sqlite] High Ascii in path causes database load failures

2006-10-12 Thread Teg
Hello G., The Dr has solved it. SQlite's looking for UTF8 which is the same as ASCII except in the presence of high order characters. Thanks. C Thursday, October 12, 2006, 9:52:08 AM, you wrote: GRS> On Thu, 2006-10-12 at 13:19 +, [EMAIL PROTECTED] wrote: >> Teg <[EMAIL PROTECTED]>

Re: [sqlite] High Ascii in path causes database load failures

2006-10-12 Thread G. Roderick Singleton
On Thu, 2006-10-12 at 13:19 +, [EMAIL PROTECTED] wrote: > Teg <[EMAIL PROTECTED]> wrote: > > Hello sqlite-users, > > > > I'm on a US English version of windows XP, latest patches. From time > > to time my users report that they can't open a database that's > > clearly sitting there in the

Re: [sqlite] High Ascii in path causes database load failures

2006-10-12 Thread drh
Teg <[EMAIL PROTECTED]> wrote: > Hello sqlite-users, > > I'm on a US English version of windows XP, latest patches. From time > to time my users report that they can't open a database that's > clearly sitting there in the file system. > > I've tracked the problem down to high ascii in the

[sqlite] High Ascii in path causes database load failures

2006-10-12 Thread Teg
Hello sqlite-users, I'm on a US English version of windows XP, latest patches. From time to time my users report that they can't open a database that's clearly sitting there in the file system. I've tracked the problem down to high ascii in the path. For instance D:\DataBoy\GROUPS.DB3 works

Re: [sqlite] Journal file and EFS space

2006-10-12 Thread drh
chetana bhargav <[EMAIL PROTECTED]> wrote: > whats the optimal amount of EFS usually that we have to reserve so atleast > the user can delete one object from the table so that he can make further > deletes. > I think you will likely need 10-20K of space for the journal in some cases. In the

Re: [sqlite] new sqlite-based webserver

2006-10-12 Thread Günter Greschenz
hi raymond, your idea of including other files is already done. there is a function "script" (see "gas,js") which includes other files. that how i want to support different "applications". on example is "notes". in "apps/notes.js" i implemented the ajax backend, in "www/Notes/*" i implemented

Re: [sqlite] problem in deleting

2006-10-12 Thread Markus Hoenicka
Narendran <[EMAIL PROTECTED]> was heard to say: > i am deleting ,it does delete. but i am trying to delete again, no error > code is returned, See http://www.sqlite.org/lang_delete.html: "If a WHERE clause is supplied, then only those rows that match the expression are removed." If no rows

Re: [sqlite] problem in deleting

2006-10-12 Thread Narendran
hi , I like to say it properly, i am deleting ,it does delete. but i am trying to delete again, no error code is returned, Narendran -- View this message in context: http://www.nabble.com/problem-in-deleting-tf2428522.html#a6771299 Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] problem in deleting

2006-10-12 Thread Narendran
hi , i got a confusion in deleting a entry, sqlite> create table hai (key text primary key,value text) ; sqlite> create table hai (key text primary key,value text) ; SQL error: table hai already exists sqlite> insert into hai (key,value) values ('hai1','value1'); sqlite> insert into hai