in reply to RFC: Placeholder creation for SQL statements

This node falls below the community's threshold of quality. You may see it by logging in.
  • Comment on Re: RFC: Placeholder creation for SQL statements

Replies are listed 'Best First'.
Re^2: RFC: Placeholder creation for SQL statements
by choroba (Cardinal) on Mar 09, 2018 at 15:22 UTC
    > DBI already has the ability to pass an array of placeholder values to a query so that they will be substituted for the ? marks left-to-right.

    But it only works if you know the number of the placeholders in advance, which is exactly the problem the OP tries to solve.

    ($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord
}map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,

    [download]
[reply]
[d/l]
Re^2: RFC: Placeholder creation for SQL statements
by LanX (Saint) on Mar 09, 2018 at 16:14 UTC
[reply]

In Section Meditations