I've entered this as OpenBD bug #193 http://code.google.com/p/openbluedragon/issues/detail?id=193
I will look into getting it fixed. Matt On Tue, Jan 19, 2010 at 3:37 PM, Matthew McGinty <[email protected]> wrote: > 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 !!
