Hi there - I'm doing my first steps with the Google datastore and now
have a select-problem:
<cfset resultArray = GoogleQuery("SELECT FROM dj WHERE date >
'2010-07-01' AND date < '2010-07-03'")>
This gives the following error in OBD: "Portion of expression could
not be parsed: AND date < '2010-07-03'" resp. "Syntax error: SELECT
FROM dj WHERE date > '2010-07-01' AND date < '2010-07-03'"
However, when I enter this command in the Data Viewer from Google
("SELECT * FROM dj where date > '2010-07-01' and date < '2010-07-03'")
this works without any problems and gets the correct results.
Does anybody know if this problem is related to OBD?
Kind regards,
Thomas
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
online manual: http://www.openbluedragon.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
