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 !!
