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

Reply via email to