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
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
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
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>
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
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[_]
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...
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
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
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
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]>
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
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
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
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
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
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
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.
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
19 matches
Mail list logo