This problem does not happen for me. It works fine for me. Surround the value in your query with single quotes like this:
select from team where COUNTRYID == '#form.country_id#' Does that help? Matt On Mon, Jan 18, 2010 at 10:16 AM, Matthew McGinty <[email protected]> wrote: > I will look into this. > > On Sat, Jan 16, 2010 at 6:47 AM, Nurettin Omer Hamzaoglu > <[email protected]> wrote: >> Matthew, >> >> I've downloaded the latest openbd-gae.zip and tried the above code >> without any change and it worked perfectly, thank you very much. I'll >> continue to implement my code for gae-openbd platform and will report >> back any issues I've seen. Before this changes you've made I've also >> experienced a strange problem. While my update code was duplicating >> the records, the updated records can't be retrieved with a filter >> like; >> <cfquery name="getTeams"> >> select from team where COUNTRYID == #form.country_id# >> </cfquery> >> >> My updatescript is the same as my older message; >> Team = googleRead(Form.team_key); >> Team.setTeamName("#Form.team_name#"); >> Team.setCountryID(Form.country_id); >> googleWrite(Team); >> >> The following code duplicates the records but you can't retrieve the >> newly written record even its CountryID is the same. Then I've tried >> adding returntype to getters and it works, now I can retrieve the >> duplicated record also. I don't know if this a bug which you have >> already corrected but I've seen the example Employee.cfc which also >> don't have returntype at getters and want to address this issue. >> >> Thank you for the update again, which gives me headache about a week. >> There is not enough discussions and documents around yet to address >> any errors-solutions easily. >> >> >> >> On Jan 15, 12:56 am, Matthew McGinty <[email protected]> wrote: >>> I just checked in some code changes to address this. >>> The openbluedragon.org site appears to be down at the moment, but >>> tonight a new openbd-gae.zip should be built to include these changes. >>> Once the site is back up you should be able to download it & try out >>> the changes. >>> >>> If you checkout the source code from the repository you'll find a >>> war/demo/gae/datastore/ folder which contains an Employee.cfc and an >>> index.cfm. >>> I added some new tests/examples to the bottom of that index.cfm to >>> demonstrate some of the update functionality I believe you are trying >>> to use. >>> >>> Note that with these changes it is no longer required to specify a >>> kind when using googleWrite() to write a *previously-persisted* >>> struct. >>> >>> Let me know what you think. >>> >>> Matt McGinty >>> NAC >>> >>> >>> >>> On Thu, Jan 14, 2010 at 4:05 PM, Matthew McGinty <[email protected]> wrote: >>> > I've reproduced this problem and am working on the solution. >>> > I'll let you know when I have something for you. >>> >>> > Matt McGinty >>> > NAC >>> >>> > On Mon, Jan 11, 2010 at 10:34 AM, Nurettin Omer Hamzaoglu >>> > <[email protected]> wrote: >>> >> I couldn't find a way to the object update properly. I've tried >>> >> "writeoutput(googleKey(updateObject))" and see that I get the correct >>> >> object from the datastore. But after GoogleWrite it always creates a >>> >> new object with different googlekey instead of updating the object >>> >> I've read. >>> >>> >> updateObject = googleRead(Form.team_key); >>> >> updateObject.setTeamName("#Form.team_name#"); >>> >> updateObject.setCountryID(Form.country_id); >>> >> GoogleWrite(updateObject); >>> >>> >> -- >>> >> 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 !!
