Today's Google App Engine nightly build (dated 2010-02-03) contains an updated version of demo/gae/datastore/index.cfm. Please download and run it on your system. The very last test should find 1 record. If that works for you, please modify the last query to be: select from Employee where age == 99
Does that work for you? If so, then please provide a simple example which I could run here to see this problem. Matt On Wed, Feb 3, 2010 at 2:44 AM, Nurettin Omer Hamzaoglu <[email protected]> wrote: > Throws the following error. > > CFML Runtime Error > illegal argument in range: select from team where COUNTRYID == '1' > > Type Application > Detail Filters of type java.lang.Character are not supported > > > On Feb 2, 8:49 pm, Matthew McGinty <[email protected]> wrote: >> What happens if you put single-quotes around the 1 like this: >> >> select from team where COUNTRYID == '1' >> >> Matt M. >> >> On Tue, Feb 2, 2010 at 7:02 AM, Nurettin Omer Hamzaoglu >> >> >> >> <[email protected]> wrote: >> > There are about 20 records with COUNTRYID = 1 but the following query >> > doesn't retrieve any records. >> >> > <cfquery name="getTeams"> >> > select from team where COUNTRYID == 1 >> > </cfquery> >> >> > -- >> > Open BlueDragon Public Mailing List >> > http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon >> > mailing list -http://groups.google.com/group/openbd?hl=en >> >> > !! save a network - please trim replies before posting !! > > -- > Open BlueDragon Public Mailing List > http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon > mailing list - http://groups.google.com/group/openbd?hl=en > > !! save a network - please trim replies before posting !! -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
