SQL IN() function

[Mike Kerner]

and, I have found that IN doesn't like parameter substitution, for whateve
reason.

On Fri, May 22, 2015 at 4:26 AM, Peter Haworth <pete at lcsql.com> wrote:

> IN works fine in sqlite to find any item in the supplied list. Having said
> that, I've never used it with a BLOB type. Can't tell from your post but is
> there a reason you're using BLOB rather than INTEGER?
>
> How is your devicelist formatted?
>
> Pete
> lcSQL Software
> On May 21, 2015 10:10 AM, "Bob Sneidar" <bobsneidar at iotecdigital.com>
> wrote:
>
> > Okay, once again it’s Regex to the rescue.
> >
> > There is no function in sqLite to do this sort of thing. Instead one can
> > use a series of LIKE statements like so:
> >
> > SELECT * FROM formsgen.service where devicelist LIKE '6480,%'
> >         OR devicelist LIKE '%,6480'
> >         OR devicelist LIKE '%,6480,%'
> >         OR devicelist = ‘6480'
> >
> > this covers first, last, middle and only conditions
> > Bob S
> >
> >
> > > On May 21, 2015, at 09:14 , Bob Sneidar <bobsneidar at iotecdigital.com>
> > wrote:
> > >
> > > Hi all.
> > >
> > > I am having a problem with a query. I have the value “647,6480” in a
> > column called devicelist. I use the query:
> > >
> > > SELECT * FROM formsgen.service where 647 in(device list);
> > >
> > > It returns one record as it should. However if I use the query:
> > >
> > > SELECT * FROM formsgen.service where 6480 in(device list);
> > >
> > > I get NO RECORDS. Am I misunderstanding the IN function? BTW the column
> > is a BLOB type. Not sure if that matters.
> > >
> > > Bob S
> > >
> > >
> > > _______________________________________________
> > > use-livecode mailing list
> > > use-livecode at lists.runrev.com
> > > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."