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