Understanding WRI (EZWriter) page URLs



  • Tony Costantino (DeBartolo Performing Arts Center)

    How can I pass a list of values for a parameter, e.g. SPACE, in order to select several spaces in a query where clause, e.g. "where EV700_SPACE in (!SPACE!)"

  • There may be a better way to do this, but this should work;

    WHERE (!SPACE!) LIKE '%|' + EV700_SPACE + '|%'

    Pass your space list like |LOBBY|FLAGPOLE|FOYER|

    Hope that helps


  • Emily Crank

    Lee is pretty much spot on here.  Unfortunately, SQL does not support a parameter in an IN clause.  

    If you are using this for an EZWriter URL, make sure to URL encode your characters (https://www.w3schools.com/TAGs/ref_urlencode.asp). A pipe in a URL will get rejected by the server, but should be OK if you correctly encode it (%7C).

Please sign in to leave a comment.