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 <[email protected]> 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" <[email protected]> > 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 <[email protected]> > > 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 > > > [email protected] > > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ > use-livecode mailing list > [email protected] > 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." _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
