AnsweredAssumed Answered

I am trying to use the IN keyword.

Question asked by PSI on Sep 4, 2015
Latest reply on Sep 7, 2015 by PSI

I am trying to use the IN keyword.

 

  ExecuteSQL (

  "SELECT Summary

  FROM Events

  WHERE \"Date\"=? AND Status IN (?) AND Location=?"; ""; "¶"; zG_DateCal[7] ; zL_FilterByStatus ; "Mainspace" )

 

zL_FilterByStatus =

  Case ( IsEmpty ( zG_FilterByStatus ) or zG_FilterByStatus = "All" ;

  "'Confirmed'" & ", " & 'Hold'" & ", " & 'Cancelled'" ; zG_FilterByStatus )

 

If zL_FilterByStatus = 'Confirmed', 'Hold', 'Cancelled' I get nothing.

If zL_FilterByStatus = any individual work, without single quotes, it works.

 

any ideas?

thanks

John

Outcomes