Yes, the current implementation only works for variables in the CFC "variables" scope. Our plans are to update the CFC persistence syntax to match the ColdFusion 9 ORM feature:
http://forta.com/blog/index.cfm/2009/7/7/ORM-Rethinking-ColdFusion-Database-Integration Vince On Sun, Aug 30, 2009 at 1:01 PM, Paul Kukiel<[email protected]> wrote: > > Hi Vince, > > Thanks I actually did try that initially but it didn't work. It did get me > thinking however. > > My in my cfc's I was using: > <cfproperty name="topSpeed" type="numeric" default="300" /> > > Swapping to: > <cfset variables.topSpeed = 300 /> > > Works fine. > > Looks like the sql doesn’t work for <cfproperty /> > > Paul. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Vince Bonfanti > Sent: Sunday, August 30, 2009 12:48 PM > To: [email protected] > Subject: [OpenBD] Re: GAE Data store and CFC's > > > Try changing "select from MyCarLot where Car.topSpeed == 300" to > "select from MyCarLot where topSpeed == 300" and see what happens. > > Vince > > On Sun, Aug 30, 2009 at 11:42 AM, Paul Kukiel<[email protected]> wrote: >> I’m a little bit stuck here: >> >> >> >> I can read and write to the datastore and can filter structs but I can’t >> figure out how to filter on cfc’s. I looked through the demos in the GEA >> source and can’t see an example. If anyone can stop what I am doing >> incorrectly in the filter sql that would be helpful. >> >> >> >> I tried a number of ways here is the sample code and the URL to view the >> output: >> >> >> >> http://pcfflex.appspot.com/ >> >> >> >> <cfscript> >> >> employees = GoogleQuery( "select from MyCarLot" ); >> >> GoogleDelete( employees ); >> >> >> >> CFObj = CreateObject("component", "Car").init(4,"Big",false,300); >> >> >> >> keyString = googleWrite(CFObj, "MyCarLot"); >> >> >> >> </cfscript> >> >> <cfquery dbtype="google" name="resultArray"> >> >> select from MyCarLot >> >> </cfquery> >> >> All: >> >> <cfdump var="#resultArray#" /> >> >> >> >> Filter: >> >> <cfquery dbtype="google" name="resultArray"> >> >> select from MyCarLot where Car.topSpeed == 300 >> >> </cfquery> >> >> <cfdump var="#resultArray#" /> >> >> >> >> Vanilla object: >> >> <cfdump var="#CFObj#" /> >> >> >> >> Paul. >> > > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
