Posted on 2005-09-29 01:26:48-07 by dmanura
ANNOUNCE: SQL-Interpolate 0.31

SQL-Interpolate 0.31 is now available on CPAN: http://search.cpan.org/dist/SQL-Interpolate/ .

This includes a new ("WHERE", {x => \@v, ...}) syntax, bug fixes, and clarified documentation.

Changes 0.31 2005-09-27 ## SQL::Interpolate - Improved error reporting by sql_interp (recommended by mark stosberg) - Added support for ("WHERE", {x => \@v, ...}) ==> "WHERE (x IN (?,...) AND ...)". (recommended by multiple people) - Generate 'WHERE id = 5 and 1=1' and 'WHERE id = 5 or 1=0' rather than 'WHERE id = 5 and 1' and 'WHERE id = 5 or 0' for Oracle compatibility. (reported by wojciech pietron) - Fixed some improper handling of "use" parameters, e.g. $x in "use SQL::Interpolate FILTER=>$x" - Fixed various Exporter problems from custom import (reported by mark stosberg) - sql_interp.t and dbi.t - Fixed test case errors due to different hash order on MacOS. (reported by sean davis) - Documentation improvements. ## SQL::Interpolate::Macro - Fixed: '^' and '$' are no longer automatically placed around regexes in 'relations' parameter. (reported by wojciech pietron) ## DBIx::Interpolate - Added support for transparent caching of statement handles (no need to prepare()). - Fixed error in STX::fetchrow_hashref returning an arrayref rather than a hashref. (reported by mark tiefenbruck) - Added Carp
Direct Responses: Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.