DBD::SQL::Nano ORDER BY statements ending in ;?

2013-12-13 Thread Mark Lawrence
I'm getting the the following error using DBI::SQL::Nano: DBD::DBM::db prepare failed: Bad ORDER BY clause ';' at /home/wose/.cpan/build/DBI-1.630-ZpcutD/blib/ lib/DBI/DBD/SqlEngine.pm line 333. for the following statement: SELECT name, phone FROM

Re: DBD::SQL::Nano ORDER BY statements ending in ;?

2013-12-13 Thread Charles Jardine
On 13/12/13 12:06, Mark Lawrence wrote: I'm getting the the following error using DBI::SQL::Nano: DBD::DBM::db prepare failed: Bad ORDER BY clause ';' at /home/wose/.cpan/build/DBI-1.630-ZpcutD/blib/ lib/DBI/DBD/SqlEngine.pm line 333. for the following statement:

Re: DBD::SQL::Nano ORDER BY statements ending in ;?

2013-12-13 Thread Mark Lawrence
See the last paragraph of the following subsection of the DBI documentation: http://search.cpan.org/~timb/DBI/DBI.pm#prepare It says: Some command-line SQL tools use statement terminators, like a semicolon, to indicate the end of a statement. Such terminators should not normally be