This queue is for tickets about the Class-DBI CPAN distribution.

Report information
The Basics
Id:
2971
Status:
resolved
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
corion [...] cpan.org
Cc:
AdminCc:

BugTracker
Severity:
Normal
Broken in:
0.93
Fixed in:
(no value)



Subject: transform_sql does only single replacements
The sub transform_sql() does only replace the first occurrence of the pattern, and not all occurrences : __PACKAGE__->table('Actors'); __PACKAGE__->set_sql( actors_in_strip => 'SELECT __TABLE__.id FROM __TABLE__, panels_and_actors, Panels WHERE id = Panels_and_Actors.actor and Panels_and_Actors.panel = panels.id and panels.strip = ?'); results in : SELECT Actors.id FROM __TABLE__, panels_and_actors, Panels WHERE id = Panels_and_Actors.actor and Panels_and_Actors.panel = panels.id and panels.strip = ? instead of : SELECT Actors.id FROM Actors, panels_and_actors, Panels WHERE id = Panels_and_Actors.actor and Panels_and_Actors.panel = panels.id and panels.strip = ? Adding a /g modifier resolves this problem.
Date: Sat, 19 Jul 2003 12:36:17 +0100
From: Tony Bowden <tony@kasei.com>
To: via RT <bug-Class-DBI@rt.cpan.org>
Subject: Re: [cpan #2971] transform_sql does only single replacements
RT-Send-Cc:
Show quoted text
> The sub transform_sql() does only replace the first occurrence of the pattern, and not all occurrences :
Thanks. This has been fixed, and should be in the new version - hopefully released before I go to YAPC::EU next week. Tony
This was fixed in version 0.94 which was released a few weeks ago. Thanks for catching this, and I hope the new version does what you need! Tony


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.