Re: Dynamic SQL Bind values

[davidrw]

Check out SQL::Abstract -- it goes further and eliminates the need for the "INSERT ..." sql snippet (and has SELECT, UPDATE, DELETE and WHERE clause support).

use SQL::Abstract;
my $sa = SQL::Abstract->new;
my($sql, @bind) = $sa->insert('YOUR_TABLE', \%value_for_column);
$dbhandle->do($sql, {}, @bind);

[blogical]

Thanks, that looks like a handy dandy module. This is just a snippet that I've ended up finding use for a few times now and thought I'd share. Less featureful than SQL::Abstract, but when the shoe fits (and doesn't require buying a matching outfit to boot...)