AnsweredAssumed Answered

Query has no results return depend on the data?

Question asked by MayMay on Sep 30, 2014
Latest reply on Sep 30, 2014 by rscheitlin

Here is my query where clause:

query1.where = "(name) ='" + dom.byId("SUB").value + "'";

When I run a query, 90% query will return results except if the data has "  ' ".  For example, if my data has a name called "BRIAN'S ESTATES" then query won't return any results even though you enter the exact same name.  Got ideas to change the where clause?

 

Thanks.

Outcomes