Re: [sqlite] Getting an unexpected result

2014-10-16 Thread jose isaias cabrera
"Richard Hipp" wrote... On Thu, Oct 16, 2014 at 7:16 PM, Keith Medcalf wrote: Although the parser does not care how you format your query, human readability is improved by using nice formatting. Indeed, the error would have likely been spotted much faster had the query been reformatted

Re: [sqlite] Getting an unexpected result

2014-10-16 Thread Richard Hipp
On Thu, Oct 16, 2014 at 7:16 PM, Keith Medcalf wrote: > > Although the parser does not care how you format your query, human > readability is improved by using nice formatting. > Indeed, the error would have likely been spotted much faster had the query been reformatted for readability. That sh

Re: [sqlite] Getting an unexpected result

2014-10-16 Thread Keith Medcalf
N '2014-10-01' AND '2014-10-01') GROUP BY id; Although the parser does not care how you format your query, human readability is improved by using nice formatting. >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.or

Re: [sqlite] Getting an unexpected result

2014-10-16 Thread jose isaias cabrera
"jose isaias cabrera" wrote... Greetings! I am trying to create a report with this query, select id, ProjID, PClass, PSubClass, bdate, lang, wDir From LSOpenJobs Where cust = 'PIPA' AND fromLang = 'EN-CA' AND (lang = 'DE-DE' OR lang = 'PT-BR') AND PSubClass LIKE '%-Trans' OR PSubClass Like '%-

[sqlite] Getting an unexpected result

2014-10-16 Thread jose isaias cabrera
Greetings! I am trying to create a report with this query, select id, ProjID, PClass, PSubClass, bdate, lang, wDir From LSOpenJobs Where cust = 'PIPA' AND fromLang = 'EN-CA' AND (lang = 'DE-DE' OR lang = 'PT-BR') AND PSubClass LIKE '%-Trans' OR PSubClass Like '%-Valid' AND (PClass = 'Language