that should read devicelist stupid spel corect. :-) 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
