1 of 1 people found this helpful
I don't have a problem. But I don't see a closing " after the email address.
ExecuteSQL ( "select f_CheckFieldStatus from account where UserAccountName = ?" ; "" ; "" ; "firstname.lastname@example.org" )
The field may need to be indexed (mine did).
There is a closing quote in the original statement, I simplified it for this forum.
Statement from script:
ExecuteSQL ( "Select f_MyCreditApplications from Account where UserAccountName = ? " ; "" ; "" ; Account::cUser )
I also checked and the UserAccountName field is indexed. The statement works on all other accounts, just not the one with a "-" in the string.
email@example.com is the email/account I am trying to find.
ExecuteSQL is case sensitive and must be exact in matching.
your example worked for me.
something else may be going on.
Did you check the "Account" is the active table at the script?
As beverly says it may be a case issue, try wrapping the UserAccountName field in a Lower function,
so your statement will look like this
ExecuteSQL ( "select f_CheckFieldStatus from account where lower ( UserAccountName ) = ?"
; "" ; "" ; lower ( "firstname.lastname@example.org" ) )
Hope this helps
Thanks everybody for the input. It was a case issue.