SQL SELECT Statement problem

[Bob Sneidar]

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 <pete at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode