Ticket #28 (closed defect: fixed)

Opened 3 years ago

Last modified 2 years ago

isLike and isNotLike failing when value is same size of field maxlength

Reported by: beau.holton@… Owned by: dhughes
Type: defect Priority: normal
Milestone: Component: Reactor - Gateway
Version: Severity: normal
Keywords: Cc:

Description

The isLike and isNotLike functions of abstactGateway.cfc are both failing when the size of the variable is within two characters of the maxlength specified in the database. To fix this I added +2 to the maxlength of the "Anywhere" case and +1 to the maxlength of the "Left" and "Right" cases of the functions.

Attachments

isLike-fix.patch (6.5 kB) - added by beau.holton@… 3 years ago.
patch file for ticket #28
isLike-fix.2.patch (6.5 kB) - added by beau.holton@… 3 years ago.
patch file for ticket #28

Change History

Changed 3 years ago by beau.holton@…

patch file for ticket #28

Changed 3 years ago by beau.holton@…

patch file for ticket #28

Changed 3 years ago by dhughes

  • status changed from new to closed
  • resolution set to fixed

(In [299]) Fixes #28. This problem was related to the fact that the "%" characters used for the isLike and isNotLike methods are counted as characters when passed into cfqueryparam tags. To fix this I added 2 to the length for the anywhere mode and 1 to the length of the Left and Right modes.

Note: See TracTickets for help on using tickets.