Item12236: SQLFORMAT and continue="off" not working when using bindValues

SQLFORMAT does work with continue="off" when using the params attribute in %SQL% as the params are not stored in the cache.

The following modification in Core.pm work for me:

diff Core.pm_orig Core.pm
144a145
>       bindVals => \@bindVals,
180a182
>   my $bindVals = $entry->{bindVals};
187c189
<       $sth->execute or
---
>       $sth->execute(@{$bindVals}) or

Basicly the bindVals are added to the cache and reused when executing the query in handleSQLFORMAT. I'm not a perl hacker, so I'm not sure if this is the correct/best way of passing and dereferencing the parameter array.

Hope that helps, Frank

-- FrankHoellering - 12 Nov 2012

Commenting is disabled while not logged in