AnsweredAssumed Answered

Execsql not reading parameter with dash

Question asked by geo63 on Oct 3, 2016
Latest reply on Oct 4, 2016 by geo63

I have an ExecuteSQL statement to read the account table by the email address and pickup a field value.  I use the email address as the account username.


ExecuteSQL ( "select f_CheckFieldStatus from account where UserAccountName = ?" ; "" ; "" ; " )


This statement seems to have a problem with the '-' character in the domain name.  Has anyone ever encountered this problem and can offer a solution?


The Find method works fine as long as I put "==" & in the search field.