Omit the values keyword since you do not have any values (you are using a
select instead).
INSERT OR REPLACE INTO SONGS (skipcount)
SELECT substr( custom5, 1, 4)
FROM SONGS
WHERE custom5 > '%'
and skipcount < cast(substr(custom5, 1, 4) as int);
the Values clause introduces a
Paolo Bolzoni wrote:
> What do you mean with "if you do not ATTTACH databases"?
EncFS does not implement .fsyncdir, which is used by SQLite when
deleting the master journal file. Such a file is used for transactions
when there are multiple database files, i.e., when you have used ATTACH.
But I
On 23 Sep 2013 at 04:50, pisey phon wrote:
> I got an error "Call to undefined method SQLite3Result::numRows()". and here
> is my code:
> $db = new Sqlite3("sample.db");
> $result = $db->query("select * from table");
> $rows = $result->numRows();
Sorry, ignore my last
On 09/20/2013 11:30 PM, Carey, John wrote:
Hello,
I am trying to write a simple perl program (perl version 5.16.3). I am
accessing a SQLite db which is using WAL(write ahead logging). It took me a
while but I learned that my connection is only looking at the DB file and not
the WAL file. As
On 23 Sep 2013 at 04:50, pisey phon wrote:
> I got an error "Call to undefined method SQLite3Result::numRows()". and here
> is my code:
> $db = new Sqlite3("sample.db");
> $result = $db->query("select * from table");
> $rows = $result->numRows();
Don't do that. Do:
As far as I know the only way to know the number of returned
rows is scanning all the query result. Isn't it?
On Mon, Sep 23, 2013 at 5:48 PM, John McKown
wrote:
> Basically, this is telling you that there is no such function as
> "Sqlite3::numRows". I did a fast
Roger,
Thank you, I will start working on it per your suggestions, though I would
love to get mine cleaned up easily, I want to provide a solution that other
users can use :)
On Sun, Sep 22, 2013 at 11:14 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
>
You are using a binding, right?
Please, can you show the problem with the plain C interface?
On Mon, Sep 23, 2013 at 5:50 AM, pisey phon wrote:
> Dear Sqlite Team
>
>
> I have some problem with Sqlite3.
>
>
> Would you mind if I want to ask you a question?
>
>
> I got an
Basically, this is telling you that there is no such function as
"Sqlite3::numRows". I did a fast scan of the sqlite3 documentation, and
there does not appear to be a sqlite3 function which returns this type of
information. The PHP interface appears to just be a wrapper for PHP around
existing
What do you mean with "if you do not ATTTACH databases"?
I should not use the ATTACH DATABASE command to add
a second database to a connection or I cannot use a db at
all?
On Mon, Sep 23, 2013 at 3:43 PM, Clemens Ladisch wrote:
> Paolo Bolzoni wrote:
>> I was wondering, is
Dear sqlite users
I have some problem with Sqlite3. Would you mind if I want to ask you a
question?
I got an error like this:
Call to undefined method Sqlite3Result:: numRows().
Here is my code:
$db = new Sqlite3("sample.db");
$result = $db->query("select * from table");
$rows =
Dear Sqlite Team
I have some problem with Sqlite3.
Would you mind if I want to ask you a question?
I got an error "Call to undefined method SQLite3Result::numRows()". and here
is my code:
$db = new Sqlite3("sample.db");
$result = $db->query("select * from table");
$rows = $result->numRows();
Paolo Bolzoni wrote:
> I was wondering, is using sqlite3 under EncFs safe?
> For "safe" I mean is the db is strong against data corruption
> as in a usual filesystem?
EncFS implements the .fsync callback but not .fsyncdir, so the deletion
of the master journal is not synchronized, so your data
Dear list,
I was wondering, is using sqlite3 under EncFs safe?
For "safe" I mean is the db is strong against data corruption
as in a usual filesystem?
Do anyone has experience? It would be reasonably easy to
test?
Your faithfully,
Paolo
___
To the OP:
I've got a tonne of media on my Drobo, and I feel your pain. Between my
MP3s, pictures, videos and books, keeping tabs on file names, physical file
locations, its quite the nightmare, and by the sounds of it, Roger has been
exposed to this issue more so than I have been, and with my
Hi!
SQL Maestro Group announces the release of SQLite Code Factory 13.9, a
powerful Windows GUI solution for querying SQLite databases and managing the
data.
http://www.sqlmaestro.com/products/sqlite/codefactory/
Please note that before Oct 13 you can purchase all our products and bundles
The administrator just told me, the server is on debian with CIFS, each machine
are on Ubuntu.
i try to remember the whole session :
me :
sqlite3 birth.sqlite
create table people ...
insert into people values('o','1')
and no closing sqlite
all other at the same time (but probably not at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 22/09/13 19:41, Kristopher Roy wrote:
> I have a table of songs, several have similar titles I can't find where
> to get started. I tried this but its not right. Select SongTitle,
> COUNT(SongTitle) AS LIKE_COUNT FROM Songs
I did work with a
18 matches
Mail list logo