Re: [sqlite] Compare and INSERT INTO syntax issue

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

Re: [sqlite] EncFs + sqlite3

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

Re: [sqlite] Problem with method numRows() in Sqlite3

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

Re: [sqlite] question on WAL files

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

Re: [sqlite] Problem with method numRows() in Sqlite3

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:

Re: [sqlite] Problem with method numRows() in Sqlite3

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

Re: [sqlite] Compare Similar Cells

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- >

Re: [sqlite] Problem with method numRows() in Sqlite3

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

Re: [sqlite] Problem with method numRows() in Sqlite3

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

Re: [sqlite] EncFs + sqlite3

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

[sqlite] Sqlite3

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 =

[sqlite] Problem with method numRows() in Sqlite3

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();

Re: [sqlite] EncFs + sqlite3

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

[sqlite] EncFs + sqlite3

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 ___

Re: [sqlite] Compare Similar Cells

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

[sqlite] SQLite Code Factory 13.9 released

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

Re: [sqlite] multiple connection to the same DB

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

Re: [sqlite] Compare Similar Cells

-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