I have a force.com site, it has a visualforce page with a controller that is doing a very simple SOQL query to the database, which for some reason it's not returning any records.
Here's what I've covered: read access to account and contact objects; removed the "Where" clause from my Select and it's still not returning any records at all; also, I've tested the page in SF an it works fine... anyone know something I'm missing?!
Here is the query:
list <Contact> sfContacts = [Select Id, FirstName, LastName, Email, AccountId, Account.Name, Account.Domain__c
From Contact
Where Email =: myUser.myEmail
And Name like :pattern];
Thanks! eclf