Are you building a samples and loops site?
On Mon, Jul 5, 2010 at 12:52 PM, Tom <[email protected]> wrote:
> 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
>
--
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
