Hi,
beginner question: i installed python, sqlite3 in linux with step:
1cd sqlite-3.6.22
2./configure --prefix=/home/omc/daisy/python/
3make
4make install
when i run the python, and want to import sqlite3, error at:
Python 2.5.2 (r252:60911, May 26 2010,
I have fixed the problem with google's help:
just _sqlite3.so is not installed correctly.
i reinstall python, the problem is gone.
thanks.
--
From: zeal zealx...@hotmail.com
Sent: Wednesday, May 26, 2010 2:59 PM
To: General Discussion of SQLite
We all know UPDATE sometimes is limited so in order to make some complex
conditional updating we can only rely on the complexity of WHERE clause.
I would like to update my detail table based on master properties (so to set
some value only if the corresponding master record fits some conditions).
On 26 May 2010, at 9:21am, Max Vlasov wrote:
UPDATE detail_table SET somefield=somevalue
WHERE
(SELECT masterfieldtocheck FROM master_table WHERE master_table.id
=detail_table.masterid)=okvalue
Is there a way to alias the master table when I need to check several fields
of the master
Max Vlasov wrote:
We all know UPDATE sometimes is limited so in order to make some complex
conditional updating we can only rely on the complexity of WHERE clause.
I would like to update my detail table based on master properties (so to set
some value only if the corresponding master record
where exists (
select 1 from master_table where
master_table.id=detail_table.masterid and
masterfieldtocheck = okvalue and
masterfield2tocheck = okvalue2);
-- or
where detail_table.masterid in (
select id from master_table where
masterfieldtocheck = okvalue and
While implementing a table that intended for arbitrary table storage, I
automatically named some field rowid not linking at the moment that it will
have a name conflict with sqlite internal rowid name. Lately I discovered
this, and (not a big deal) recreated table with a different name. But just
While implementing a table that intended for arbitrary table storage, I
automatically named some field rowid not linking at the moment that it
will
have a name conflict with sqlite internal rowid name. Lately I discovered
this, and (not a big deal) recreated table with a different name. But
Of course if you define a column rowid integer primary key then the
declared column and the internal rowid are one and the same...
As an extension of this, if you are in the habit of relying on the internal
rowid rather than having your own specifically declared integer primary
key *and* use
On Wed, May 26, 2010 at 6:19 PM, Pavel Ivanov paiva...@gmail.com wrote:
But just
wondering, was allowing to create such field intentional? As I suppose
such
field is complete phantom since most sql queries will interpret rowid
internally and won't allow access this user field at all.
How do I search for the asterix character * ??
This doesn't work:
select field1 from table1 where field1 like '%FH%*%'
as the * character here seems to be ignored.
Using the latest version of SQLite.
RBS
___
sqlite-users mailing list
How do I search for the asterix character * ??
This doesn't work:
select field1 from table1 where field1 like '%FH%*%'
as the * character here seems to be ignored.
Using the latest version of SQLite.
You're doing it right. Either you use a wrapper that messes with * in
litterals or there is
Yes, thanks, it looks it might indeed be the (VB) wrapper that is to blame here.
Will contact the developer.
RBS
On Wed, May 26, 2010 at 5:53 PM, Jean-Christophe Deschamps
j...@q-e-d.org wrote:
How do I search for the asterix character * ??
This doesn't work:
select field1 from table1 where
I use vb or in SQLlite Expert the * does not seem to work
From my testing * doesn't seem to work in the likeif I use '%33' it returns
everything with test33if I use '33%' it returns everything with 33testif I
use '%33%' it returns everything with 33test, test33 which is the same as
*
Hope this
This works for me:
sqlite create table t(t varchar);
sqlite insert into t values('Testing*with asterisk');
sqlite insert into t values('Testing without asterisk');
sqlite select * from t;
Testing*with asterisk
Testing without asterisk
sqlite select * from t where t like '%*%';
Testing*with
I use vb
What wrapper is that?
RBS
On Wed, May 26, 2010 at 6:14 PM, ro...@zhole.com ro...@zhole.com wrote:
I use vb or in SQLlite Expert the * does not seem to work
From my testing * doesn't seem to work in the likeif I use '%33' it returns
everything with test33if I use '33%' it returns
Yes, it must be either my code or the wrapper to blame.
Thanks for confirming.
RBS
On Wed, May 26, 2010 at 6:18 PM, Black, Michael (IS)
michael.bla...@ngc.com wrote:
This works for me:
sqlite create table t(t varchar);
sqlite insert into t values('Testing*with asterisk');
sqlite insert
On 26 May 2010, at 6:24pm, Sam Carleton wrote:
212-456-7890
212-789-1234
212-564-9875
212-357-8452
212-285-6100
560-851-5522
If searching for a number with '56', I want to get back: 212-4*56*-7890,
212-*56*4-9875, and *56*0-851-5522, NOT 212-28*5-6*100. Is FTS the right
answer or is
Does anyone know where I can download a LIB and DLL pre- built for
Win7-64bit?
I am in the process of converting C/C++ projects from Win XP to Win7-64bit
and don't want to build the DLL myself.
Carl Buhrke
___
sqlite-users mailing list
Or to more directly answer the question...
select * from phone where number like '%56%';
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin
Sent: Wed 5/26/2010 12:25 PM
To:
Bart Smissaert bart.smissa...@gmail.com
schrieb im Newsbeitrag
news:aanlktil5lha-3-l6x8umwv8e3pyrda6h0ln3dcoyh...@mail.gmail.com...
Yes, it must be either my code or the wrapper to blame.
Thanks for confirming.
It's a wrapper-problem, but a perhaps a coding problem
as well... ;-)
The wrapper
...Where SomeColumnContent Like '%someother[*]part%'
Thanks Olaf, that works fine.
As my customers won't get this I think I might let my code take care of this.
How would it work with glob?
RBS
On Wed, May 26, 2010 at 7:05 PM, Olaf Schmidt s...@online.de wrote:
Bart Smissaert
I use vb or in SQLlite Expert the * does not seem to work
From my testing * doesn't seem to work in the likeif I use '%33' it
returns
everything with test33if I use '33%' it returns everything with
33testif I
use '%33%' it returns everything with 33test, test33 which is the same as
*
I can't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/26/2010 10:24 AM, Sam Carleton wrote:
If I do opt to use FTS, which one should I be using, FTS1 or FTS2?
According to the web site, it should be FTS1, correct?
Just as a matter of interest what part of the web site led you to those
On Wed, May 26, 2010 at 1:47 PM, Roger Binns rog...@rogerbinns.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/26/2010 10:24 AM, Sam Carleton wrote:
If I do opt to use FTS, which one should I be using, FTS1 or FTS2?
According to the web site, it should be FTS1, correct?
Just
Bart Smissaert bart.smissa...@gmail.com
schrieb im Newsbeitrag
news:aanlktikivzcbz81hqs28dtptoy8h6hc6nbukesmth...@mail.gmail.com...
...Where SomeColumnContent Like '%someother[*]part%'
Thanks Olaf, that works fine.
As my customers won't get this I think I might let my
code take care of
Glob works fine as well with the [*] and is still case-sensitive and
that is how it is intended.
So this works fine:
select field1 from table1 where field1 glob '*FH*[*]'
RBS
On Wed, May 26, 2010 at 8:22 PM, Olaf Schmidt s...@online.de wrote:
Bart Smissaert bart.smissa...@gmail.com
schrieb
I am looking for an SQL engine that is easy to install and sqlite seems like
the right way to go. I have an application (currently just for network use
on a LAN) and I want to move to using SQL, my application is fairly small
and simple and I like the idea of embedding SQL and using SQLite so my
On 26 May 2010, at 10:04pm, jdee5 wrote:
I am looking for an SQL engine that is easy to install and sqlite seems like
the right way to go. I have an application (currently just for network use
on a LAN) and I want to move to using SQL, my application is fairly small
and simple and I like
Thanks for your reply. I have read through the link you suggested, very
helpful...if I may ask another question concerning this. Say on my
application I have 2 users reading some of the database contents at the same
time and they both log something in my application at the same time. For
On Wed, May 26, 2010 at 8:15 PM, jdee5 jonidm...@yahoo.com wrote:
Thanks for your reply. I have read through the link you suggested, very
helpful...if I may ask another question concerning this. Say on my
application I have 2 users reading some of the database contents at the same
time
P-
The application I sell is quite small and simple embedded db seems easier to
deploy. My current install takes just a few minutes and so it doesn't seem
like a good idea to have to have my customer have to configure a
client/server database I need something quick and simple. I tried out MS
On 27 May 2010, at 2:15am, jdee5 wrote:
hanks for your reply. I have read through the link you suggested, very
helpful...if I may ask another question concerning this. Say on my
application I have 2 users reading some of the database contents at the same
time and they both log something in
Roger,
I did this search:
http://www.google.com/search?q=sqlite+text+search
The top link points here:
http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex
Thus I learned of FTS1 and FTS2, maybe things should be configured so that
CVS isn't crawled by search engines ;)
Sam
On Wed, May 26, 2010
On Wed, May 26, 2010 at 9:22 PM, Sam Carleton
scarle...@miltonstreet.com wrote:
Roger,
I did this search:
http://www.google.com/search?q=sqlite+text+search
The top link points here:
http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex
Thus I learned of FTS1 and FTS2, maybe things should
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/26/2010 07:22 PM, Sam Carleton wrote:
I did this search:
http://www.google.com/search?q=sqlite+text+search
Thanks. I have updated the relevant wiki pages to say the information is
old and to point to the current FTS3 implementation.
Thanks for the suggestions:
Sqlite Manager also fails.
This is a permission issue with the sql open api. This is a Shared Folder
under VirtualBox with read only permission. If the folder is tagged as full
access then sql open works.
There should be no reason that the openv2 statement
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/26/2010 08:45 PM, Art wrote:
There should be no reason that the openv2 statement with read_only specified
should fail under these circumstances,
Just because you are opening the database read only does not mean that other
connections in
38 matches
Mail list logo
