On Thu, 03 Sep 2015 16:44:50 +
Peter Haworth wrote:
> The statement I'm using is:
>
> SELECT * FROM myTable WHERE myKey IN (:1)
>
> If the value I supply to be used as :1 is a single integer, the SELECT
> finds the correct rows. If the value is a comma separated list of
> integers, e.g
I use a high level language to write my db applications (Livecode). It
permits the use of replacement opertaors in sql statements, e.g. "SELECT *
FROM myTable WHERE myKey=:1". I guess that's a standard way of doing
things in SQLite.
I'm having some issues with this and not sure whether it's a
On 9/3/15, Peter Haworth wrote:
>
> SELECT * FROM myTable WHERE myKey IN (:1)
>
> If the value I supply to be used as :1 is a single integer, the SELECT
> finds the correct rows. If the value is a comma separated list of
> integers, e.g 1,2 the SELECT statement does not return any rows and no
>
3 matches
Mail list logo