ExecuteSQL on multikey field returns single result

[James Gill]

I'm performing relatively simple select statement that is using criteria from a multi-keyed global field to perform the select

 

The statement is basically

 

ExecuteSQL(
"SELECT
Table1.fieldName
FROM
Table1
WHERE
Table1.id = ? ; "" ; "" ; <MULTIKEYEDGLOBALFIELD> )

 

The query works but it is only returning a single result even when there are multiple keys in the global field.  Any suggestions?

[James Gill]

I figured this one out myself.  I used the IN operator that allows you to search within a comma separated list of values, thusly:

Let ( [
                ~query  = "SELECT table1.field FROM table1 WHERE table1.field IN (" & Substitute ( <multi-keyed values> ; "¶" ; "," ) & ")"
                ] ;

ExecuteSQL ( ~query ; "" ; "" ) 
)

[Andreiev]

Thanks!!! This just saved me a lot of time.