no viable alternative at character ''

Question

I'm getting this error when trying to execute the following. I get my deadline date from a Visualpage which is binded directly to a controller.

QueryException: line 1:322 no viable alternative at character ' '

My Query being executed:

 Select c.CaseNumber,c.Status,c.ID, Account.Name, Account.Status__c, Account.Type,Account.Location_Type__c,Account.BillingCountry,Contact.Name, Contact.Email FROM Case c where c.BatchNumber__c = 'a0dR0000003dfBbIAI' and c.Deadline_Date__c = 2012-11-16 00:00:00

My Code:

  Date deadline = CaseParameter.Deadline_Date__c;
  soql = 'Select c.CaseNumber,c.Status,c.ID, Account.Name, Account.Status__c, Account.Type,Account.Location_Type__c,Account.BillingCountry,Contact.Name, Contact.Email  FROM Case c  where c.BatchNumber__c = \''+batchNumber+'\''; 
  soql+= ' and c.Deadline_Date__c = '+deadline;

superfell · Answer 1 · 2013-01-23T16:19:23.240

2

Your date should be 2012-11-16T00:00:00Z . note the T separator, rather than a space between the date & time components, and the addition of a Timezone indicator at the end (GMT in this case)

From apex, you can use the query binding feature, rather than building a soql string, e.g.

Date deadline =CaseParameter.Deadline_Date__c;
List<Case> cases = [select caseNumber,id,Account.Name from Case where deadline__date__c=:deadline];

edited Jan 23 '13 at 16:19

answered Jan 23 '13 at 15:46

superfell

18,780
4
59
81

But how do I do that ? I thought if I add the deadline(which is a date) it should do it automatically. – raym0nd Jan 23 '13 at 16:11
the reason I use a soql string is that I build my query dynamically based on the user input. – raym0nd Jan 23 '13 at 16:29
Thanks, I'll see what I can do. – raym0nd Jan 23 '13 at 16:40

score 1 · Accepted Answer · answered Jan 24 '13 at 10:58

1

datetime deadline =  datetime.newInstance(CaseParameter.Deadline_Date__c,Time.newInstance(0, 0, 0, 0));
  soql = 'Select c.CaseNumber,c.Status,c.ID, Account.Name, Account.Status__c, Account.Type,Account.Location_Type__c,Account.BillingCountry,Contact.Name, Contact.Email  FROM Case c  where c.BatchNumber__c = \''+batchNumber+'\''; 
  soql+= ' and c.Deadline_Date__c = '+deadline.format('yyyy-MM-dd');

answered Jan 24 '13 at 10:58

Shimshon Korits

1,189
6
10

3

Please include some english explanation. – brandones Feb 27 '15 at 20:32

no viable alternative at character ''

2 Answers2