Re: [sqlite] Proper way to escape table name and column name

2011-06-07 Thread Paul Linehan
2011/6/6 Jean-Christophe Deschamps : >>What is the official way to escape table name that contains a space >>and column name that contain a spaces? > You can use square brakets or double-quotes: > [This is a long name for a small table] > "This is a long name for a small table as well" Or, wha

Re: [sqlite] Proper way to escape table name and column name

2011-06-06 Thread Richard Hipp
On Mon, Jun 6, 2011 at 6:14 AM, Jean-Christophe Deschamps wrote: > > >What is the official way to escape table name that contains a space > >and column name that contain a spaces? > > You can use square brakets or double-quotes: > > [This is a long name for a small table] > "This is a long name fo

Re: [sqlite] Proper way to escape table name and column name

2011-06-06 Thread Jean-Christophe Deschamps
>What is the official way to escape table name that contains a space >and column name that contain a spaces? You can use square brakets or double-quotes: [This is a long name for a small table] "This is a long name for a small table as well" ___ sqli

[sqlite] Proper way to escape table name and column name

2011-06-06 Thread Marco Bambini
What is the official way to escape table name that contains a space and column name that contain a spaces? Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/m