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
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
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
>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
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
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
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
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
-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
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
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
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
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
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
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
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
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 |
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
>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
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
>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
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
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
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
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
25 matches
Mail list logo