Re^2: Converting from MySQL to SQLite

everything else work fine , it seem

            if($sth2->rows() <= 0)
[download]

I check the data in SQLite there are more then one row, but why it enter this 'if' statement. the output are 'No data in your list, please add.' when there is data in SQLite

Comment on Re^2: Converting from MySQL to SQLite Download Code

Replies are listed 'Best First'.
Re^3: Converting from MySQL to SQLite by davido (Cardinal) on Jul 29, 2004 at 15:44 UTC
Well, in the code you presented, I see that '$sth2->rows()' is called, and later on, '$sth->finish()' is called. So you have two statement handles open at the same time. The SQLite Home Page has a page that describes common SQL features not implemented in SQLite. The list is short, but one item on it says, "Nested Transactions: The current implementation only allows a single active transaction." See http://www.sqlite.org/omitted.html. Dave	[reply]

Replies are listed 'Best First'.

Re^3: Converting from MySQL to SQLite
by davido (Cardinal) on Jul 29, 2004 at 15:44 UTC

The SQLite Home Page has a page that describes common SQL features not implemented in SQLite. The list is short, but one item on it says, "Nested Transactions: The current implementation only allows a single active transaction." See http://www.sqlite.org/omitted.html.

Dave

[reply]