Hi,
I execute the SQL statement [SELECT Name FROM tr069;] and get the result
InternetGatewayDevice.DeviceInfo.
InternetGatewayDevice.DeviceInfo.AdditionHardwareVersion
InternetGatewayDevice.DeviceInfo.AdditionalSoftwareVersion
InternetGatewayDevice.DeviceInfo.Description
Yes, thats it! Missing "extension=sqlite.so" in my php.ini. Now
apt-get brings the 'sqlite.so' with it.
Thanks Gopal ! :-)
On Tue, Jun 24, 2008 at 4:04 PM, Gopal Venkatesan
<[EMAIL PROTECTED]> wrote:
> - "Philipp Morath" <[EMAIL PROTECTED]> wrote:
>
>> Thanks you Gopal.
>> Nothing about
Hi James,
I think the problem lies with your expectations.
Read the section on the LIKE operator in http://www.sqlite.org/lang_expr.html
Rgds,
Simon
2008/6/25 James <[EMAIL PROTECTED]>:
> Hi,
>
> I execute the SQL statement [SELECT Name FROM tr069;] and get the result
>
>
Hi,
I will read that.
But I want to know that is it possible to get the expected result?
Thank you.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies
Sent: Wednesday, June 25, 2008 3:57 PM
To: General Discussion of SQLite Database
Subject: Re:
I can get your expected results from the data you have given, as shown below:
sqlite> CREATE TABLE tst( name text );
sqlite>
sqlite> insert into tst values( 'InternetGatewayDevice.DeviceInfo.' );
sqlite> insert into tst values( 'RubbishForTesting.DeviceInfo.1' );
sqlite> insert into tst values(
Hi, Simon:
Thanks for help me solve this problem.
I have study the link you give me. But I still don't understand why
my original SQL statement can't work. Could you explain in detail?
Thank you.
James
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
You seemed to be expecting that
name NOT LIKE 'InternetGatewayDevice.%.[1-9]' AND name NOT LIKE
'InternetGatewayDevice.%.[^1-9]
would exclude some of the rows you are getting.
This is incorrect. The only wild cards affecting operation of the LIKE
operator are '%' and '_'.
Regards,
Simon
I have a question for which I couldn't find much in this list or in
sqlite.org website: the pros are ovious, but what are the cons of
compiling with -DSQLITE_ENABLE_COLUMN_METADATA?
I guess there must be some, if that's not compiled by default.
What's the concern?
Code size? (this would not be a
On 6/25/08, James <[EMAIL PROTECTED]> wrote:
> Hi, Simon:
> Thanks for help me solve this problem.
> I have study the link you give me. But I still don't understand why
> my original SQL statement can't work. Could you explain in detail?
You are expecting the LIKE (or NOT LIKE)
Hello,
How can I change the schema of this table to keep the optimzation and allow
to have two same 'time'?
CREATE TABLE events(
time REAL NOT NULL PRIMARY KEY,
detections BLOB);
CREATE INDEX idxTime ON events (time ASC);
Thanks in advance.
KINDT Raphaël
Hello,
with the following schema and contents:
BEGIN TRANSACTION;
CREATE TABLE a(id INTEGER);
INSERT INTO a VALUES(1);
INSERT INTO a VALUES(2);
INSERT INTO a VALUES(3);
CREATE TABLE b(id INTEGER);
INSERT INTO b VALUES(NULL);
INSERT INTO b VALUES(3);
INSERT INTO b VALUES(4);
INSERT INTO b
On Jun 25, 2008, at 11:33 AM, [EMAIL PROTECTED] wrote:
> Hello,
>
> with the following schema and contents:
>
> BEGIN TRANSACTION;
> CREATE TABLE a(id INTEGER);
> INSERT INTO a VALUES(1);
> INSERT INTO a VALUES(2);
> INSERT INTO a VALUES(3);
> CREATE TABLE b(id INTEGER);
> INSERT INTO b
Raphaël KINDT <[EMAIL PROTECTED]>
wrote:
> How can I change the schema of this table to keep the optimzation and
> allow to have two same 'time'?
>
> CREATE TABLE events(
>time REAL NOT NULL PRIMARY KEY,
>detections BLOB);
>
> CREATE INDEX idxTime ON events (time ASC);
Just
Why should the second query return zero rows? Clearly ids 1 and 2 don't
exist in b. I'm not defending sqlite per se, just asking, logically
speaking, why would those other databases return zero rows for that
query?
On a related note, what if NULL exists in both tables? Sqlite doesn't
return
On Jun 25, 2008, at 12:12 PM, Wilson, Ron P wrote:
> Why should the second query return zero rows? Clearly ids 1 and 2
> don't
> exist in b.
The meaning of "NULL" in SQL is overloaded. In some contexts NULL
means "anything" or "unknown". In other contexts it means "nothing".
If we
Ah. Thanks for the clarification. It seems to me that using NULL as
'anything' or 'unknown' - it becomes a wildcard of sorts and could
create a lot of confusion in queries.
note to self : use NULL with extreme caution.
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
On Jun 25, 2008, at 12:48 PM, Wilson, Ron P wrote:
> It seems to me that using NULL ... could
> create a lot of confusion in queries.
Yes, yes. SQL-NULL excels at creating confusion!
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
Is this the correct list for airing SQLite amalgamation compilation problems?
-- Charlie Springer
**
Gas prices getting you down? Search AOL
Autos for fuel-efficient used cars.
(http://autos.aol.com/used?ncid=aolaut000507)
The lesson is very clear from the evidence. With SQL NULL is ambiguous
and subject to intepretation so good design requires that you completely
avoid it. Then you sidestep intractable implementation interptrations.
A project management technique dating back further than I can remember
was to
Is there a way in a user program to get the db file name that has been
associated with a particular sqlite3* ?
Dan Winslow, GamePlan
402-991-5875 x219
[EMAIL PROTECTED]
Third Nerd from the left,Technology Defenestration Office
___
sqlite-users mailing
Well, NULL is not a value, technically, it is the lack of a value.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P
Sent: Wednesday, June 25, 2008 11:12 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] bug with NULL in NOT
On Jun 25, 2008, at 2:23 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]
> wrote:
> Is there a way in a user program to get the db file name that has been
> associated with a particular sqlite3* ?
>
PRAGMA database_list;
D. Richard Hipp
[EMAIL PROTECTED]
Small. Fast. Reliable.
Choose any three
==>
Small. Fast. Reliable. Free.
Choose any four
:)
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am trying to convert a VB 2005 program from a SQLExpress database to
SQLite 3. I have been successful up to the following line of code:
Me.Dbo_UsersTableAdapter.Update(Me.TSEPWin5UserSQLiteDB.dbo_Users)
It seems that the DboTableAdapter does not support the Update command. What
is the
D. Richard Hipp wrote:
>
> If I understand Peter correctly, he is saying that NULL should mean
> "unknown" in the context of the RHS of a NOT IN operator. SQLite does
> not currently operate this way. SQLite currently interprets a NULL in
> the RHS of a NOT IN operator to mean "nothing".
[EMAIL PROTECTED] wrote:
> Is this the correct list for airing SQLite amalgamation compilation problems?
>
Yes.
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Try using this library
http://sqlite.phxsoftware.com/
It a complete ADO.NET 2 implementation and it should support the update.
On Wed, Jun 25, 2008 at 5:14 PM, Richard W. Kulp <[EMAIL PROTECTED]>
wrote:
> I am trying to convert a VB 2005 program from a SQLExpress database to
> SQLite 3. I have
I have no way of knowing which rows a select command has visited for an
indexed table.
create table t(a);
create index it on t(a);
insert ...
select * from t where a=5;
Is there a select hook for debugging?
Thanks,
-Alex
___
sqlite-users mailing list
I'm not exactly sure what they've built on top of my (free) provider, but it
looks like a good portion of their core codebase is my code. It's a bummer
they decided to split with the free spirit of SQLite and charge for their
provider (based on my public domain code), but to each his own.
Robert
I tried to post this once and didn't see it. Is there a restriction on long
listings? I'll cut off most of it this time.
Hi all. I'm new to SQLite. It was recommended by a friend who uses it on
PDA's and cell phones. I am trying to compile the Amalgamation on a version of
gcc
set up for ARM
Alex Katebi wrote:
> I have no way of knowing which rows a select command has visited for an
> indexed table.
>
> create table t(a);
> create index it on t(a);
> insert ...
> select * from t where a=5;
>
> Is there a select hook for debugging?
How about:
explain select * from t where a=5;
"P Kishor" <[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> You are expecting the LIKE (or NOT LIKE) operator to behave like a
> RegExp operator. No, it doesn't. It just has a single wildcard
> specifier, the % sign.
Two of them: % (a sequence of zero or more of arbitrary
This is a "known" issue.
http://www.sqlite.org/cvstrac/tktview?tn=2508,6
The fix is to include SYSGEN_CORELOC.
Can someone mention that in the documentation somewhere?
Ryan
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:sqlite-users-
> [EMAIL PROTECTED] On Behalf Of Ryan Clark
On Wed, Jun 25, 2008 at 08:19:35PM -0400, [EMAIL PROTECTED] scratched on the
wall:
> I tried to post this once and didn't see it. Is there a restriction on long
> listings? I'll cut off most of it this time.
>
> Hi all. I'm new to SQLite. It was recommended by a friend who uses it on
> PDA's
The only wild cards affecting operation of the LIKE operator are '%' and
'_'.
So the SQLite doesn't support '[ ]' and '^'. Right?
Thank you.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Simon Davies
Sent: Wednesday, June 25, 2008 5:35 PM
To: General
Robert,
I looked at CoreLab's provider recently and didn't get the impression that
they used your code at all. It's separate DLL's, very different classes, is
missing some functionality that you provide (like custom functions written
in .NET) but has other functionality (like robust connection
Roosevelt,
Thanks. That worked perfectly.
Dick
On Wed, 25 Jun 2008 18:17:39 -0400, Roosevelt Anderson
<[EMAIL PROTECTED]> wrote:
>Try using this library
>
>http://sqlite.phxsoftware.com/
>
>It a complete ADO.NET 2 implementation and it should support the update.
>
>On Wed, Jun 25, 2008 at
Steven,
If SQLite runs on ARM9/Linux, then I don't see any problems. I think you
should watch the SQLite video on youtube.
http://www.youtube.com/watch?v=giAMt8Tj-84
Enjoy!
-Alex
2008/6/24 Steven Woody <[EMAIL PROTECTED]>:
> Hi,
>
> I am considering to use SQLite in my current embedded
Hello all,
I recently got an error while running a long query with sqlite3 on
Ubuntu Gutsy 7.10:
SQL error: disk I/O error
I googled for a solution but didn't find anything relevant. After a
bit of sleuthing on my machine, I discovered that I was running out of
disk space. I freed up some
Hi,
I found in wikipedia that Lemon parser is a part of SQLite project but i
couldn't found any sort of information regarding to LEMON.
Can u give me any documentation regarding how to install it and how to work
for some programs on Lemon parser generator or any URL's that might be
helpful and can
40 matches
Mail list logo
