This issue seems related to Bug #193: http://code.google.com/p/openbluedragon/issues/detail?id=193
I had "fixed" that bug in the OpenBD-GAE code, but recently found that my fix was invalid and that the issue is not due to any bug in BD. So I rolled back that "fix" in the OpenBD-GAE code. Basically the *type* that is specified for the parameter can effect how it must be used in a query. The test case mentioned in the bug report: /demo/gae/datastore/index.cfm & Employee.cfc is checked into the OpenBD-GAE repository. Employee.cfc was using type="String" for a function parameter when instead it should have been using type="Numeric". If Numeric is used then the value in the query must be treated as a number (no single-quotes). So maybe check the type of your CountryID Matt M. On Wed, Feb 3, 2010 at 9:52 AM, Matthew McGinty <[email protected]> wrote: > 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 !!
