RE: [PHP-DEV] SQLite API deficiency

2004-05-13 Thread Stanislav Malyshev
WF>>Can the compile/step definitely not handle multiple queries? WF>>That's a shame :/ Manual says: The sqlite_compile "compiles" a single SQL statement (specified by the second parameter) and generates a virtual machine that is able to execute that statement. /.../ If the 2nd parameter actually

Re: [PHP-DEV] SQLite API deficiency

2004-05-13 Thread Ilia Alshanetsky
On May 13, 2004 09:25 am, Stanislav Malyshev wrote: > I have discovered that SQLite function sqlite_query runs sqlite_exec > function if it's return value is used and sqlite_compile/sqlite_step combo > if return value is used. I think this is a problem - if I want to run some > pack of queries (lik

RE: [PHP-DEV] SQLite API deficiency

2004-05-13 Thread Wez Furlong
I've been bitten by this too, but didn't get time to delve into it. Can the compile/step definitely not handle multiple queries? That's a shame :/ I'm currently in DB API mode (working on PDO), so I'll refresh my memory and do some sqlite stuff over the next few days; if there is no way to get th