What does the App Engine datastore viewer show the value of for COUNTRY for those entities?
If they're datastore.Key objects, then you're not going to be able to use CFQUERY to query against them. On May 18, 2:43 am, Nurettin Omer Hamzaoglu <[email protected]> wrote: > Is it possible to query key object? > > I've a list of countries and when a country is selected from select > list I want to retrieve all cities. My city kind has a > key(com.google.appengine.api.datastore.Key) field which I store countr > key. It works when using java but couldn't manage to use it in > cfquery. > > JDO definition > ----------------------- > City > @Persistent > private String CITY_NAME; > > @Persistent > private Key COUNTRY; > > I want to run a query like; > <cfquery dbtype="google" name="getCities"> > select from city where COUNTRY == '#Form.CountyKey#' > </cfquery> > > Form.CountyKey is a string something like > ahFxdWFsaXR5LWFzc3VyYW5jZXILCxIEY2l0eRjBAQw > > I tried sting to key method but no luck. > <cfquery dbtype="google" name="getCities"> > select from city where COUNTRY == > '#keyFactory.stringToKey(Form.CountyKey)#' > </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 !!
