Re^2: Flexible Update SQL

in reply to Re: Flexible Update SQL
in thread Flexible Update SQL

But this does not solve the problems:

passing null parameters...

placement of the comma...

Comment on Re^2: Flexible Update SQL

Replies are listed 'Best First'.
Re^3: Flexible Update SQL by roboticus (Chancellor) on Dec 02, 2010 at 02:53 UTC
bichonfrise74: Actually, placeholders do handle the null parameter. Constructing the update statement can do the rest... `my @fields = qw(name phone city country); my $SQL = "update table set " . join(", ", map { "$_=?" } @fields) . "where ...."; my $ST=$DB->prepare($SQL); while (...) { my @values = (.....); $ST->execute(@values); }` [download] ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: Flexible Update SQL
by roboticus (Chancellor) on Dec 02, 2010 at 02:53 UTC

bichonfrise74:

Actually, placeholders *do* handle the null parameter. Constructing the update statement can do the rest...

my @fields = qw(name phone city country);
my $SQL = "update table set "
.         join(", ", map { "$_=?" } @fields)
.         "where ....";
my $ST=$DB->prepare($SQL);
while (...) {
    my @values = (.....);
    $ST->execute(@values);
}
[download]

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[reply]
[d/l]

In Section Seekers of Perl Wisdom