Re: Dynamic SQL Bind values

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);
[download]

Comment on Re: Dynamic SQL Bind values Download Code

Replies are listed 'Best First'.
Re^2: Dynamic SQL Bind values by blogical (Pilgrim) on Apr 22, 2006 at 21:11 UTC
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...) "One is enough. If you are acquainted with the principle, what do you care for the myriad instances and applications?" - Henry David Thoreau, Walden	[reply]

Replies are listed 'Best First'.

Re^2: Dynamic SQL Bind values
by blogical (Pilgrim) on Apr 22, 2006 at 21:11 UTC

"One is enough. If you are acquainted with the principle, what do you care for the myriad instances and applications?"
- Henry David Thoreau, Walden

[reply]