AnsweredAssumed Answered

Errors occurred while building or executing SQL statement

Question asked by hannahb on Sep 18, 2018
Latest reply on Sep 18, 2018 by Sjaak Overgaauw

I am using a Flow service and would like to match the user input to a field in a database. Every time I try this I am getting an error.  

Below I have added my process. I have tried adding a decision shape after the database connector however am still receiving the error. 

The Profile statement is 

SELECT ActivityId, BccAddress, CcAddress, CreatedById, CreatedDate, FromAddress, FromName, HasAttachment, Headers, HtmlBody, Id, Incoming, IsClientManaged, IsDeleted, IsExternallyVisible, LastModifiedById, LastModifiedDate, MessageDate, MessageIdentifier, ParentId, ReplyToEmailMessageId, Status, Subject, SystemModstamp, TextBody, ThreadIdentifier, ToAddress, ValidatedFromAddress FROM EMAILMESSAGE
WHERE ToAddress=?

The parameter is Email. 

 

The full error message is 

 

 

Any help with this would be really appreciated. 

 

Thanks

 

Hannah

Outcomes