Item12245: Enahance handling of bind parameters which contain ','
Priority: Enhancement
Current State: Closed
Released In: n/a
Target Release:
Applies To: Extension
Component: SqlPlugin
Branches: trunk
The current implementation splits the params attribute on each comma to create the array of bindVals.
This was not working for me when the one or more parameters are strings an contained a comma as well.
To fix this I quoted my variable and changed
my @bindVals = split '\s*,\s*', $theParams;
to
use Text::ParseWords;
my @bindVals = parse_line( '\s*,\s*',0, $theParams);
Maybe this is worth to be included in a future release of this plugin.
--
FrankHoellering - 13 Nov 2012