Re: [sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

On Tue, 27 Jul 2010 22:56:23 -0700, Roger Binns wrote: >You can if you quote it. Note use double quotes to quote table & column >names, single quotes for strings. You can also quote names using square >brackets - eg [table name]. Thanks Roger for the tip.

Re: [sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

On 28 Jul 2010, at 6:56am, Roger Binns wrote: > This works: > > create table ""("" ""); The obfuscated SQLite contest closed three months ago. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/27/2010 05:48 AM, Gilles Ganault wrote: > Found it: For newbies like me... "table" is a reserved name so cannot > be used as a name to table: You can if you quote it. Note use double quotes to quote table & column names, single quotes for

Re: [sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

On Tue, 27 Jul 2010 14:40:11 +0200, Gilles Ganault wrote: >I'm having a problem with this PHP5 script running under Nginx + >PHP5-FPM and PDO-SQLite3 Found it: For newbies like me... "table" is a reserved name so cannot be used as a name to table: #BAD

[sqlite] [PHP5-FPM/Sqlite3] PDO can create file but no more

Hello I'm having a problem with this PHP5 script running under Nginx + PHP5-FPM and PDO-SQLite3: = exec("CREATE TABLE IF NOT EXISTS table (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(255))"); $dbh->exec("INSERT INTO table (name) VALUES ('dummy')"); $dbh = null;