Re: Converting from MySQL to SQLite

If I'm not mistaken, SQLite currently only supports one active statement handle at a time. You have $sth2 and $sth active at the same time. I seem to remember that SQLite just won't "do that".

Dave

Comment on Re: Converting from MySQL to SQLite

Replies are listed 'Best First'.
Re^2: Converting from MySQL to SQLite by Anonymous Monk on Jul 29, 2004 at 08:49 UTC
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	[reply] [d/l]
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]