Item12245: Enahance handling of bind parameters which contain ','

pencil
Priority: Enhancement
Current State: Closed
Released In: n/a
Target Release:
Applies To: Extension
Component: SqlPlugin
Branches: trunk
Reported By: FrankHoellering
Waiting For:
Last Change By: MichaelDaum
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

 

ItemTemplate edit

Summary Enahance handling of bind parameters which contain ','
ReportedBy FrankHoellering
Codebase
SVN Range
AppliesTo Extension
Component SqlPlugin
Priority Enhancement
CurrentState Closed
WaitingFor
Checkins SqlPlugin:01c886bf5e46
ReleasedIn n/a
CheckinsOnBranches trunk
trunkCheckins SqlPlugin:01c886bf5e46
Release01x01Checkins
Topic revision: r3 - 18 Mar 2014, MichaelDaum
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy