[fpc-pascal] Sqldb - How to pass an array of values as a param to be used with SQL IN operator?

[Stephen Chrzanowski]

The problem with that Tony is that the the bind might make :myparam a
string, so you'll be doing a 1-integer to 1-string comparison, which won't
give you any results.  Essentially you'll be asking for a list of results
whos field is equal to "1,2,3,4", not a list of results in which the field
in question contains the numbers 1, or 2, or 3, or 4.

At OP

Due to the nature of the bind mechanism, you won't be able to do it this
way.  The only way you'll be able to do that is with your program doing
string substitution instead of doing the bind.  Since you're dealing with
integers only, you'll just need to make sure that every entry you're
substituting for is actually an integer.


On Sun, Apr 10, 2016 at 10:01 AM, Tony Caduto <tony.caduto at gmail.com> wrote:

> Did you try putting quotes around the param ID in the sql query?
> in(":myparam")
> I am guessing it's the commas that are the problem.
>
> Sqlite will accept double qoutes as will MySQL postgres will not though.
> On Apr 10, 2016 7:40 AM, "leledumbo" <leledumbo_cool at yahoo.co.id> wrote:
>
>> > But until now i havent figured a way to pass an array of values (mostly
>> integers) to be used with IN operators.
>>
>> That, unfortunately, is not possible. It's a DBMS limitation,
>> parameterized
>> values are actually passed as is to DBMS. So there's nothing you can do
>> unless you can convince DBMS maintainer to implement it.
>>
>> > Is there a way to accomplish this?
>>
>> No other way than direct formatting for now.
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://free-pascal-general.1045716.n5.nabble.com/Sqldb-How-to-pass-an-array-of-values-as-a-param-to-be-used-with-SQL-IN-operator-tp5724873p5724874.html
>> Sent from the Free Pascal - General mailing list archive at Nabble.com.
>> _______________________________________________
>> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
>> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>>
>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20160410/81c4277f/attachment.html>