Mrs. Brisby wrote:
chances are you can't use threads correctly either. This mailing list is
an excellent example of how many "professional programmers" simply can't
deal with threads- every problem they run into, it's "how do I make
sqlite work with threads".
If you have to ask that question, yo
I tried that but got: "no such collation sequence: NUMERIC"
"Dan Kennedy"
On Mon, 2005-07-25 at 09:00 +0100, Ben Clewett wrote:
> I like what you say about computer science being a Science. This is
> exactly my point. A science is a collection of theories which hold true
> within a domain until otherwise dissproven. For instance Isac Newtons's
> law of gravety and
On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote:
> The theory has been proposed that threads aren't better than separate
> processes, or application implemented context switching. Does anyone
> have an experiment that will prove the point either way? It will have
> to be OS specific though, s
David Fowler wrote:
Really sorry guys, AS files, should indeed be AS tables, thats what
does not work. Sorry again for the copy/pasting/editing error. When I
remember to name everything correctly, I still can't select anything
by table.column sytax that is in the derived table, wether the deri
Really sorry guys, AS files, should indeed be AS tables, thats what does not
work. Sorry again for the copy/pasting/editing error. When I remember to
name everything correctly, I still can't select anything by table.column
sytax that is in the derived table, wether the derived table is aliased o
Really sorry guys, AS files, should indeed be AS tables, thats what does not
work. Sorry again for the copy/pasting/editing error. When I remember to
name everything correctly, I still can't select anything by table.column
sytax that is in the derived table, wether the derived table is aliased o
The linking did work, but I think I'm still missing something:
sudo make install
Results in:
tclsh ../tclinstaller.tcl 3.2
couldn't open ".libs/libtclsqlite3.dylib": no such file or directory
while executing
"open $LIBFILE"
invoked from within
"set in [open $LIBFILE]"
(file "../tclin
cd /usr/bin
ln -s tclsh8.4.4 tclsh
will probably do it for you, or to cover all the bases,
cd /usr/bin
ln -s tclsh8.4.4 tclsh8.4
ln -s tclsh8.4 tclsh
Regards
I've been trying to get SQLite3 installed on Mac OS X. It compiles
fine, but I get errors during the 'make install' concerning tclsh.
tclsh is there in /usr/bin/tclsh8.4.4
How should I modify the install script, or should I create a ln of
some sort for tclsh?
Oh, and /usr/bin is in my PATH.
Th
--- [EMAIL PROTECTED] wrote:
>
> Hello,
>
> I'm using sqlite3 and have a list of numbers I'd like returned sorted in
> increasing order:
> 1 1.1 1.10 1.11 1.9 10 11 9 12
>
> However, if their column is defined as numeric, the 1.10 gets converted to
> 1.1 (which is not what I want) and the res
Hello,
I'm using sqlite3 and have a list of numbers I'd like returned sorted in
increasing order:
1 1.1 1.10 1.11 1.9 10 11 9 12
However, if their column is defined as numeric, the 1.10 gets converted to
1.1 (which is not what I want) and the result (using ORDER BY) is:
1 1.1 1.1 1.11 1.9 9 10 1
David Fowler wrote:
> The problem is I can't get passed
> here. SQLite gives me a "SQL error: no such
> column: tables.id"
What is the alias "files" for? Should not it be "table"?
pf
On 7/26/05, Clark Christensen <[EMAIL PROTECTED]> wrote:
>
>
> --- David Fowler <[EMAIL PROTECTED]> wrote:
>
> > Hello again to everyone.
> > I'm having trouble with the following query:
> > SELECT tables.id FROM (
> > SELECT table4.location, table4.id
> > FROM table1
> > INNER JOIN table2 ON (t
--- David Fowler <[EMAIL PROTECTED]> wrote:
> Hello again to everyone.
> I'm having trouble with the following query:
> SELECT tables.id FROM (
> SELECT table4.location, table4.id
> FROM table1
> INNER JOIN table2 ON (table1.class_id = table2.class_id)
> INNER JOIN table3 ON (table2.name_id = ta
Hello again to everyone.
I'm having trouble with the following query:
SELECT tables.id FROM (
SELECT table4.location, table4.id
FROM table1
INNER JOIN table2 ON (table1.class_id = table2.class_id)
INNER JOIN table3 ON (table2.name_id = table3.name_id)
INNER JOIN table4 ON (table4.id = table3.id)
I
On 7/25/05, Mathieu Blondel <[EMAIL PROTECTED]> wrote:
> Hi everyone,
> I'm using sqlite3 for my project, Nihongo Benkyo, which is a japanese
> dictionary and learning tool.
Cool! I'm currently using sqlite 3.x in a lightweight japanese
dictionary of my own, Gozoku (http://dev.int64.org/gozoku.ht
On 7/25/05, Mathieu Blondel <[EMAIL PROTECTED]> wrote:
> I found out it is much more efficient to drop all the indexes, do my big
> transaction and then recreate all the indexes. Dropping indexes is not a
> really long process and just creating the indexes after the end of the
> transaction seems q
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> From the official documentation of the sqlite3_set_authorizer routine:
> "This routine registers a callback with the SQLite library. The
> callback is invoked (at compile-time, not at run-time) for each
> attempt to access a column of a table i
Martin Jenkins wrote:
v00d00 dave wrote:
Martin Jenkins schrieb:
CREATE TABLE `blacklist` (
`blcfid` int(11) NOT NULL default '0',
`blndid` int(11) NOT NULL default '0',
PRIMARY KEY (`blcfid`,`blndid`)
) TYPE=MyISAM;
If you run the sqlite3 command line utility and .read your script
From the official documentation of the sqlite3_set_authorizer routine:
"This routine registers a callback with the SQLite library. The
callback is invoked (at compile-time, not at run-time) for each
attempt to access a column of a table in the database."
What does means at compile-time and n
v00d00 dave wrote:
Martin Jenkins schrieb:
CREATE TABLE `blacklist` (
`blcfid` int(11) NOT NULL default '0',
`blndid` int(11) NOT NULL default '0',
PRIMARY KEY (`blcfid`,`blndid`)
) TYPE=MyISAM;
If you run the sqlite3 command line utility and .read your script
you'll see why it doesn
hi!
i found a solution: the problem only occurs on ubuntu(hoary) machines.
i tried my scripts on a plain sarge machine, and it worked fine!
shame on me: i _thought_ i did try on sarge before, but it was an ubuntu
machine, too.
if anyone is still interested in this bug, feel free to email, i wi
When executing 'mysqldump', use the '--compatible=ansi' flag.
Ben
Martin Jenkins wrote:
CREATE TABLE `blacklist` (
`blcfid` int(11) NOT NULL default '0',
`blndid` int(11) NOT NULL default '0',
PRIMARY KEY (`blcfid`,`blndid`)
) TYPE=MyISAM;
If you run the sqlite3 command line utility an
Martin Jenkins schrieb:
CREATE TABLE `blacklist` (
`blcfid` int(11) NOT NULL default '0',
`blndid` int(11) NOT NULL default '0',
PRIMARY KEY (`blcfid`,`blndid`)
) TYPE=MyISAM;
If you run the sqlite3 command line utility and .read your script you'll
see why it doesn't work - you need to
CREATE TABLE `blacklist` (
`blcfid` int(11) NOT NULL default '0',
`blndid` int(11) NOT NULL default '0',
PRIMARY KEY (`blcfid`,`blndid`)
) TYPE=MyISAM;
If you run the sqlite3 command line utility and .read your script you'll
see why it doesn't work - you need to change the back-ticks (`)
Try using UNION instead of OR. Several posts have mentioned that OR can
dissable the use of an index. You're also right about table order being
important, there's information on the wiki about this. I would guess
that the best order is table3, table5, table4, table2, table1 since
you're actuall
Try using UNION instead of OR. Several posts have mentioned that OR can
dissable the use of an index. You're also right about table order being
important, there's information on the wiki about this. I would guess
that the best order is table3, table5, table4, table2, table1 since
you're actuall
hi!
versions:
sqlite3: v3.2.1 with corresponding version of libsqlite3
(/usr/lib/libsqlite3.so.0.8.6)
testing oses: ubuntu hoary and debian sarge
i get various errors, if importing the attached file with
---
rm -f myproject.sqlite3
cat myproject.mysqldump \
| sed "s/\`/\"/g" \
29 matches
Mail list logo
