>> When I try to execute the same query using sqlitecc.exe it works just fine. >>
DRH> This fact suggests that the problem is in PHP or the application program, DRH> not in SQLite. There can hardly be any problem with sqlite_query($db,$query) application code... Is SQLite in PHP 5.0.2 supposed to run correctly? I'm pretty sure this is not my bug... Any success stories using PHP 5.0.2 and SQLite? Anyway, will try the same code on a Linux box, maybe it will work better.. R.
