Invalid Where Clause
Posted: Mon Nov 12, 2012 4:16 pm
Hi,
I am trying to sync contacts with my Google Account. I created a new Google account for testing, and the log kept displaying and 'invalid user id' message for my Google account. The account name was 395XXXXXX. Does Zulu not work with Google accounts that begin with numbers?
So I created another account and named it XXXXX395. I was able to sync the calendar sucessfully to this account, but when I sync contacts I get an error message "Invalid Where clause. Check for misqouted identifiers: Select "Contact ID", "Contact Phone", "Contact Label", "Contact Phone Number", "Contact Phone Type" from Zulurelatedcontacts where Contact ID = ? and Contact Phone Type = "Phone"
All of the field names in the query are the fields I mapped for phone numbers from my related Phone number table and look good.
Attached is a screen print with the complete error message.
thanks,
Christopher
I am trying to sync contacts with my Google Account. I created a new Google account for testing, and the log kept displaying and 'invalid user id' message for my Google account. The account name was 395XXXXXX. Does Zulu not work with Google accounts that begin with numbers?
So I created another account and named it XXXXX395. I was able to sync the calendar sucessfully to this account, but when I sync contacts I get an error message "Invalid Where clause. Check for misqouted identifiers: Select "Contact ID", "Contact Phone", "Contact Label", "Contact Phone Number", "Contact Phone Type" from Zulurelatedcontacts where Contact ID = ? and Contact Phone Type = "Phone"
All of the field names in the query are the fields I mapped for phone numbers from my related Phone number table and look good.
Attached is a screen print with the complete error message.
thanks,
Christopher