Okay, nice try.. :) in this case, dj = dow jones... On 5 Jul., 23:46, Baz <[email protected]> wrote: > I saw "dj" in your code and was just wondering whether your site was related > to samples & loops like some of these > sites:http://www.google.com/search?rlz=1C1CHFX_enUS384US384&sourceid=chrome... > <http://www.google.com/search?rlz=1C1CHFX_enUS384US384&sourceid=chrome...> > > > > On Mon, Jul 5, 2010 at 1:38 PM, Tom <[email protected]> wrote: > > Sorry, what do you mean by "samples and loops site"? I just try to > > save some data per day and get it back with a query... > > > On 5 Jul., 22:06, Baz <[email protected]> wrote: > > > 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
-- 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
