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
users
ORDER BY
name
;
As I understand the Nano docs the ORDER BY statement is actually ok,
but the error isn't.
If I remove the ORDER BY I get
Couldn't find WHERE clause in '
;'
For:
SELECT
name, phone
FROM
users
;
So it looks to be a general issue with a trailing ";". Am I reading
this right?
Mark.
--
Mark Lawrence