[sqlite] Some Queries.

Hello, I am a new user of this group (just joined). First of all I appreciate you for creating and maintaining such a small and robust database. I have a few simple queries on sqlite regarding footpring. I hope the owner has the answers. In sqlite features(www.sqlite.org

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

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 st

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

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.

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 inste

Re: [sqlite] insert using underscore as literal

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> sel

Re: [sqlite] Helloo...

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 Nu

Re: [sqlite] Helloo...

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...

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

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 functio

[sqlite] insert using underscore as literal

I'm trying to insert text data that includes an underscore. SQLite is removing the underscore. Is there any way to escape the underscore? -- View this message in context: http://www.nabble.com/insert-using-underscore-as-literal-tf2432375.html#a6782508 Sent from the SQLite mailing list archive

Re: [sqlite] Select ignoring accents

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 collat

[sqlite] Select ignoring accents

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

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]> wrote:

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

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 f

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

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 path.

[sqlite] High Ascii in path causes database load failures

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

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 c

Re: [sqlite] new sqlite-based webserver

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

Narendran wrote: I like to say it properly, i am deleting ,it does delete. but i am trying to delete again, no error code is returned, there is no error... """delete from hai where ;""" means: delete all records from table hai for which the test is true. doing the same delete a second ti

Re: [sqlite] problem in deleting

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 mat

Re: [sqlite] problem in deleting

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

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 (key,val