Not sure if it matters, but I use LIKE '%:1%'. Also remember that with sqLite, and unlike mySQL, this form will not find records beginning with, ending with or explicitly is whatever replaces :1. Why the implementations of the different SQL engines behave differently escapes me, other than to think that the people who develop these engines don't have a lot of respect for standards and why we need them.
Bob S > On Sep 2, 2015, at 12:52 , Peter Haworth <p...@lcsql.com> wrote: > > Having an issue with the following statement in SQLite. > > SELECT col1,col2 FROM TableA WHERE colid IN (:1) > > This is executed with > > put revQueryDatabase(gdbid,tsql,"tArray") into tCursor > > If tArray[1] contains a single integer, the SELECT works, if tArray[1] > contains a comma separated list of integers, no records are returned, even > though I know there are qualifying entries. > > If I replace ":1" in the SELECT with 1,2 the rows are correctly returned, > but if tArray[1] contains 1,2 then no rows are returned. > > On another related issue, I remember a discussion about the correct syntax > for using a parameter list variable with a LIKE statement but can't find > it. I have tried: > > LIKE ':1' with :1 containing %abc% > LIKE '%:1%' with :1 containing abc > LIKE :1 with :1 containing '%abc%' > > None of these return the correct data. Anyone remember how to get this to > work? > _______________________________________________ > 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
