Skip Menu |

This queue is for tickets about the DBD-LDAP CPAN distribution.

Report information
The Basics
Id: 50709
Status: resolved
Priority: 0/
Queue: DBD-LDAP

People
Owner: turnerjw784 [...] yahoo.com
Requestors: korsani [...] free.fr
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.09
Fixed in: (no value)



Subject: updating value with "'" fail and do not die
Updating a value with something like "update base set company='mycomp' where sn = 'd''adda' " fails : it does not update anything, and do no throw error. I made a small patch.
Subject: JLdap.patch.gz
Download JLdap.patch.gz
application/x-tar 469b

Message body not shown because it is not plain text.

On Wed Oct 21 09:53:27 2009, http://korsani.myopenid.com/ wrote: Show quoted text
> Updating a value with something like "update base set company='mycomp' > where sn = 'd''adda' " fails : it does not update anything, and do no > throw error. > I made a small patch.
A couple of questions: 1) Regarding your patch: + if (! defined($status) ) { + $self->display_error ($status); ... If $status is not defined, then it does not make sense to pass it to display_error()? 2) Have you tried escaping the quote, ie. "where sn = 'd\'adda'"? I believe that's the way it should be. Thanks, Jim
Newly-released version 0.20 fixes this bug. NOTE: When passing a string from Perl to DBD::LDAP, an escaped quote character should be preceeded by two backslashes, ie. "Richard O\\'Toole", in order to get Perl to pass the "escape" onto LDAP! Jim Turner