Re: [sqlite] WASP

2009-11-08 Thread Oftenwrong Soong
On Sat, 07 Nov 2009 21:04:59 -0500, Ted Rolle wrote: >> I'd like to see SQLite instead of MySQL as the >> database. > > You should have this already: SQLite is embedded within PHP since 5.0.0. > The SQLite library is typically not up to date, unfortunately, but it is > nevertheless there. I

Re: [sqlite] WASP

2009-11-08 Thread P Kishor
On Sun, Nov 8, 2009 at 3:34 PM, Ted Rolle wrote: > On Sun, 8 Nov 2009 14:48:08 -0600 > P Kishor wrote: > >> DBD::SQLite > Hmmm...no 4th step. That's one of the most important steps.  But then > I'm used to 12 steps... :-) > > I don't know Perl.  Is Perl 'under the covers' when I use PHP? > You m

Re: [sqlite] WASP

2009-11-08 Thread Ted Rolle
On Sun, 8 Nov 2009 14:48:08 -0600 P Kishor wrote: > DBD::SQLite Hmmm...no 4th step. That's one of the most important steps. But then I'm used to 12 steps... :-) I don't know Perl. Is Perl 'under the covers' when I use PHP? Ted ___ sqlite-users maili

Re: [sqlite] Column as a substring

2009-11-08 Thread Jean-Christophe Deschamps
>I think that my problem is in using LIKE expression for non-ascii strings. >Database encode is UTF-8. When table data in the "base" column (see my >first >message for structure) consists of english symbols (ascii) LIKE works >correct, but when I'm trying to execute it on strings consists of UTF8

Re: [sqlite] Column as a substring

2009-11-08 Thread Igor Tandetnik
Ted Rolle wrote: > SELECT * > FROM fm > WHERE name LIKE '%Julian%' > OR info LIKE '%' || name || '%' > ORDER by name; > > it returns 224 columns. > > Perhaps I'm misunderstanding the concept. > It could be returning 5 columns with 'Julian' > AND all columns where column 'name' is LIKE column in

Re: [sqlite] WASP

2009-11-08 Thread P Kishor
On Sat, Nov 7, 2009 at 8:04 PM, Ted Rolle wrote: > On Sat, 7 Nov 2009 20:39:22 -0500 > "Igor Tandetnik" wrote: > >> Ted Rolle wrote: >> > First there was LAMP (Linux, Apache, MySQL, PHP), then WAMP >> > (Windows, Apache MySQL, PHP). >> > Now we need a WASP. >> > >> > I don't relish the thought of

Re: [sqlite] Column as a substring

2009-11-08 Thread Unabashed
I think that my problem is in using LIKE expression for non-ascii strings. Database encode is UTF-8. When table data in the "base" column (see my first message for structure) consists of english symbols (ascii) LIKE works correct, but when I'm trying to execute it on strings consists of UTF8 symbo

[sqlite] Strange problem with different sqlite versions accessing the same database

2009-11-08 Thread Yuzem
I have one database on a shared folder across the network. The database is accessed by two different computers with different sqlite versions. There was no problem until I updated the OS on one of the computer. Now I have: 1: Ubuntu Hardy - sqlite3 3.4.2 2: Ubuntu Karmic - sqlite3 3.6.16 The newe

Re: [sqlite] Feature Request: Return non-0 from sqlite3 Client on Error

2009-11-08 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David E. Wheeler wrote: > I'm using -bail with the sqlite3 client, which is great, but alas > sqlite3 doesn't return a non-zero value when it bails with a failure: This was fixed in 3.6.20 most likely as fixing this: http://www.sqlite.org/src/in

Re: [sqlite] WASP

2009-11-08 Thread J. King
On Sat, 07 Nov 2009 21:04:59 -0500, Ted Rolle wrote: > WAMP ia an installable package for Windows that gives the Windows user > Apache, MySQL, and PHP. I'd like to see SQLite instead of MySQL as the > database. You should have this already: SQLite is embedded within PHP since 5.0.0. The SQLi

Re: [sqlite] Avoiding "Ambigious column"?

2009-11-08 Thread Jay A. Kreibich
On Sat, Nov 07, 2009 at 11:56:28PM +0100, Kristoffer Danielsson scratched on the wall: > > SQLite 3.6.20. > > SELECT SUM(Salary - TotalSpent) / 100 FROM (T2 NATURAL JOIN T4) NATURAL JOIN > (T2 NATURAL JOIN T3); > > Error: Ambigious column name: Salary Since you didn't tell us which tables h

Re: [sqlite] 5-second display in SQLite Manager

2009-11-08 Thread Mihai Limbasan
Hi, Ted. You have reached the mailing list for SQLite, the database engine. SQLite Manager is a completely separate, organizationally unrelated product, and we probably won't be able to help you with whatever issues you have with it. You will probably have better luck on the SQLite Manager hom

Re: [sqlite] Column as a substring

2009-11-08 Thread Unabashed
Jean-Christophe Deschamps wrote: > > > Try ... LIKE ! > select * from lemma where 'Whoever you love' like '%' || base || '%'; > If a row contains base = 'Eve' it should turn up (just an example). > > ___ > sqlite-users mailing list > sqlite-users@sq

Re: [sqlite] 5-second display in SQLite Manager

2009-11-08 Thread P Kishor
On Sun, Nov 8, 2009 at 10:24 AM, Ted Rolle wrote: > When I put the cursor over a field that is too big to fit in the column > on the screen, it displays for about 5 seconds. > What can I do to prolong the display? > Or to make it display until I move the cursor to another line. > What is the SQLi

Re: [sqlite] Column as a substring

2009-11-08 Thread P Kishor
On Sun, Nov 8, 2009 at 10:20 AM, Ted Rolle wrote: > On Sun, 8 Nov 2009 10:31:05 -0500 > "Igor Tandetnik" wrote: > >> > SELECT * >> >  FROM fm >> > WHERE name LIKE '%Juiian%' >> >   AND info LIKE '%' || name || '%' >> > ORDER by name; >> > > Thanks for seeing the oversight. > When I use > > SELECT

[sqlite] 5-second display in SQLite Manager

2009-11-08 Thread Ted Rolle
When I put the cursor over a field that is too big to fit in the column on the screen, it displays for about 5 seconds. What can I do to prolong the display? Or to make it display until I move the cursor to another line. Ted ___ sqlite-users mailing list

Re: [sqlite] Column as a substring

2009-11-08 Thread Ted Rolle
On Sun, 8 Nov 2009 10:31:05 -0500 "Igor Tandetnik" wrote: > > SELECT * > > FROM fm > > WHERE name LIKE '%Juiian%' > > AND info LIKE '%' || name || '%' > > ORDER by name; > > Thanks for seeing the oversight. When I use SELECT * FROM fm WHERE name LIKE '%Julian%' OR info LIKE '%' || name |

Re: [sqlite] Column as a substring

2009-11-08 Thread Igor Tandetnik
Ted Rolle wrote: > On Sun, 08 Nov 2009 15:06:24 +0100 > Jean-Christophe Deschamps wrote: > >> select * from lemma where 'Whoever you love' like '%' || base || '%'; > > I first tried that with this SQL statement: > > SELECT * > FROM fm > WHERE name LIKE '%Juiian%' > AND info LIKE '%' || name

Re: [sqlite] Column as a substring

2009-11-08 Thread Jean-Christophe Deschamps
>Third, my oriiginal inquiry: > >SELECT * > FROM fm > WHERE name LIKE '%Juiian%' > OR info LIKE '%Julian%' > ORDER by name; > >returned the (correct) 6 rows. BTW, if you or anyone else need a fuzzy compare function I have one that can help. It works with internally Unicode-unaccented ve

Re: [sqlite] Column as a substring

2009-11-08 Thread Ted Rolle
On Sun, 08 Nov 2009 15:06:24 +0100 Jean-Christophe Deschamps wrote: > select * from lemma where 'Whoever you love' like '%' || base || '%'; I first tried that with this SQL statement: SELECT * FROM fm WHERE name LIKE '%Juiian%' AND info LIKE '%' || name || '%' ORDER by name; returned 0

Re: [sqlite] Column as a substring

2009-11-08 Thread Jean-Christophe Deschamps
>Hello! Please, help me if you have a time for this. I have an sqlite >database >table: >CREATE TABLE lemma ( > id INTEGER PRIMARY KEY, > base TEXT, > preflex_id INTEGER, > type_ancode TEXT, > prefix_id INTEGER >) >In the "base" column I store a string which I need to compare with anoth

[sqlite] Column as a substring

2009-11-08 Thread Unabashed
Hello! Please, help me if you have a time for this. I have an sqlite database table: CREATE TABLE lemma ( id INTEGER PRIMARY KEY, base TEXT, preflex_id INTEGER, type_ancode TEXT, prefix_id INTEGER ) In the "base" column I store a string which I need to compare with another string, th

Re: [sqlite] Firefox SQLite Manager extension troubles.

2009-11-08 Thread Ted Rolle
On Sun, 08 Nov 2009 06:40:14 +0100 Gary_Gabriel wrote: > > Go to Database -> Connect Database -> Select SQLite Database -> > Browse to the new file. > It opens this SQLite file. > > - Gary Thank you for your kind answer. I've done as you said many times, but SQLite Manager still looks for the

[sqlite] bug: minor cleanup for TCLSH=2

2009-11-08 Thread Melanie Davis
The sqlite_analyzer tool broke when the btree_cursor_info functions were removed from test3.c [ec1592b266] (Jul-2009). If the sqlite_analyzer tool is no longer useful or used, the lines invoked with #define TCLSH=2 could be removed from tclsqlite.c Severity level: minor code cleanup mel

[sqlite] Feature Request: Return non-0 from sqlite3 Client on Error

2009-11-08 Thread David E. Wheeler
Greetings, I'm using -bail with the sqlite3 client, which is great, but alas sqlite3 doesn't return a non-zero value when it bails with a failure: % sqlite3 foo_test.db '.read sql/001-tables.sql' SQL error near line 3: near "autoincrement": syntax error % echo $? 0 Would it