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 = ?" ; "" ; "" ; "john.smith@my-domain.com )

 

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 "==" & john.smith@my-domain.com in the search field.

Outcomes