Because it is a list of integers, which is a string. I suppose I could have used archer, but when I am uncertain how many values might end up in the column, I always go with some kind of blob to be safe.
Bob S > On May 22, 2015, at 01:26 , Peter Haworth <p...@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" <bobsnei...@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 <bobsnei...@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
