Hi Donald,
You're right. We're using a slightly modified build of sqlite3 at the
company I work for, and it turns out that the problem is specific to our
version. The "official" build of sqlite3 doesn't have this issue. Of
course I should have tested the official binary first before jumping to
Hi,
I would like to realize the dialect between SQLite and Hibernate but
I need to know the correspondence between the SQLite types and the general
types (e.g.:How a boolean type is represented under SQLite).
What is that somebody can give myself this piece of information
because I d
guyot jerome wrote:
Hi,
I would like to realize the dialect between SQLite and Hibernate but
I need to know the correspondence between the SQLite types and the general
types (e.g.:How a boolean type is represented under SQLite).
What is that somebody can give myself this piece of i
Hello,
I use an events table which looks like this:
CREATE TABLE events(
time REAL NOT NULL,
detections BLOB);
I want to select all events which have the BIT3 of detections field enable
between two time.
How can I do that with the SELECT request?
Thanks in advance...
-
В сообщении от Monday 07 July 2008 13:42:11 Raphaël KINDT написал(а):
> Hello,
>
> I use an events table which looks like this:
>
> CREATE TABLE events(
>time REAL NOT NULL,
>detections BLOB);
>
> I want to select all events which have the BIT3 of detections field enable
> bet
Hi
I am getting odd results with a simple update query in a Mobile 6 device.
It only works sometimes , but never reports an error.
The same code works fine in PocketPC and Mobile5 devices.
UPDATE 'CommentList' SET xFlag = 3
I wondered if anyone else has seen this, and why would a query not work
"Raphaël KINDT" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> I use an events table which looks like this:
>
> CREATE TABLE events(
>time REAL NOT NULL,
>detections BLOB);
>
> I want to select all events which have the BIT3 of detections field
> enable between
I use Blob because I don't know how many bits I must use (maybe 1024 bits or
more). It's the user choice not mine.
Moreover, I think Blob takes less space than Bool field (which is TINYINT or
somethings like that).
Thanks for your reply
-Message d'origine-
De : [EMAIL PROTECTED]
[mailt
В сообщении от Monday 07 July 2008 16:38:56 Raphaël KINDT написал(а):
> I use Blob because I don't know how many bits I must use (maybe 1024 bits
> or more). It's the user choice not mine. Moreover, I think Blob takes less
> space than Bool field (which is TINYINT or somethings like that).
And ho
Is the an FTS syntax that allows me to find a field (or fields) that
start with one of the terms in the search query?
Or should I just be doing a LIKE query against the FTS table?
Jason Boehle
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-use
Jason Boehle wrote:
> Is the an FTS syntax that allows me to find a field (or fields) that
> start with one of the terms in the search query?
>
> Or should I just be doing a LIKE query against the FTS table?
Do you want any word starts with? fts_table MATCH 'st*'
will match all words like 'st
Hi, Folks.
While I do not have any expertise to compare levenshtein with other
approaches, my current approach for fuzzy matching is, taking a word
w, compute all possible near words with distance n. This is known to
generate a big number of near misses, but it is quicker to then search
for these
Hi, I have trouble getting this query to qork in sqlite, in mysql it works but
I can't get it to work in sqlite, I tried different things, aliasing table
name, without alias, I googled first ofcourse but didn't found anything... Can
somebody help, here goes sql:
SELECT COUNT(visitor_id) AS num_
On Jul 7, 2008, at 4:37 PM, Milan Nikollic wrote:
>
> SELECT
> COUNT(visitor_id) AS num_visits,
> human_year AS year,
> human_month AS month,
> human_day AS day,
> (SELECT COUNT(DISTINCT ip_address) FROM nm_visitors AS aaa
> WHERE aaa.human_year = bbb.human_year
>
Thx, actually that didn't work either, but I see now what my problem is, I was
using activerecord which in turn add this FROM (nm_visitors bbb) , when I use
normal query it is than FROM nm_visitors AS bbb and than it works...
> - Original Message -
> From: "D. Richard Hipp" <[EMAIL PROTE
On Mon, Jul 7, 2008 at 7:26 AM, Bob Dennis <[EMAIL PROTECTED]> wrote:
> Hi
> I am getting odd results with a simple update query in a Mobile 6 device.
> It only works sometimes , but never reports an error.
> The same code works fine in PocketPC and Mobile5 devices.
>
> UPDATE 'CommentList' SET x
Anyone can give me a hint, thanks so much.
Best regards!
2008-07-08
wenhm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Make sure SQLite isn't being compiled with -ffast_math on the the Debian
side. That might cause problems.
On 7/3/08, Tom Epperly <[EMAIL PROTECTED]> wrote:
>
> When I tried reproducing this behavior on a Red Hat box, the 3.5.9
> version gave the expected results, so I guess it is a Debian unstabl
also that query will update all rows in the commentlist table. is that what
you want to do?
Woody
--- On Mon, 7/7/08, Stephen Oberholtzer <[EMAIL PROTECTED]> wrote:
From: Stephen Oberholtzer <[EMAIL PROTECTED]>
Subject: Re: [sqlite] Bad UPDATE Problems in Mobile6 device
To: "General Discussio
On Mon, Jul 7, 2008 at 9:06 PM, Shane Harrelson <[EMAIL PROTECTED]> wrote:
> Make sure SQLite isn't being compiled with -ffast_math on the the Debian
> side. That might cause problems.
-ffast-math would not cause sqlite to bug out like described.
it lets the compiler reorder floating point expre
Hi,
I am interested in learning about the internals of SQLite. How it parses
SQL strings, what goes on the parsing stack, how it executes SQL
statements etc. The source code although commented is too large to read.
Is there a document I can refer to that explains how this whole process
is carried
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Aditya Bhave (adbhave) wrote:
> I am interested in learning about the internals of SQLite.
The SQLite documentation page at http://sqlite.org/docs.html contains
almost all the information you could possibly want.
> How it parses
> SQL strings, what g
22 matches
Mail list logo
