Displaying all staff records would be a gateway.
<cfset Reactor = CreateObject("Component","reactor.reactorFactory").init(expandPath("reactor.xml ")) />
<cfset staffGateway = reactor.createGateway("staff") />
<cfset qryStaff = staffGateway.getAll()>
qryStaff returns a query object, so you can use cfoutput or cfloop if you like.
I recommend reading http://livedocs.reactorframework.com/
This is covered in the "Reactor Crash Course" portion of the left navigation.
On 7/24/06, Byron Raines
<[EMAIL PROTECTED]> wrote:
Thanks, Teddy. That's really helpful. Esp. the info on isDirty (hadn't
got that far). Now to take this further. To display all staff in the
table, would I need to <cfloop> over all the records? Is this the most
efficient way? or is there another way?
Thanks again.
byron
Teddy Payne wrote:
> Byron,
> As promised, here is the reactor snippet. The reactor.xml was located
> in my webroot in a folder called sample. I created a mapping to
> sample/data folder to store the generated reactor objects.
>
> I also included a basic logic to detect if you have found an address
> for a given staffer.
>
> Reactor.xml:
> <reactor>
> <config>
> <project value="sample" />
> <dsn value="reactor" />
> <type value="mssql" />
> <mapping value="/sampleData" />
> <mode value="development" />
> </config>
>
> <objects>
>
> <object name="Staff">
> <hasOne name="Address">
> <relate from="staffID" to="staffID" />
> </hasOne>
> </object>
>
> </objects>
>
> </reactor>
>
> ColdFusion Code:
> <!--- load the reactor factory --->
> <cfset Reactor = CreateObject("Component",
> "reactor.reactorFactory").init(expandPath("reactor.xml ")) />
>
> <!--- get the staffer record for the staff person with the primary
> key on the staff table of 1 --->
> <cfset staffRecord = reactor.createRecord("staff").load(staffID=1) />
>
> <!--- get the address record for the staffer record loaded--->
> <cfset staffAddressRecord = staffRecord.getAddress() />
>
> <!--- the isDirty method of the staffer's address link will tell you
> if an address record was found or not for the staffer --->
> <cfset badRead = staffAddressRecord.isDirty()>
>
> <cfoutput>
> <!--- display the staffer's name from the staff table' --->
> #staffRecord.getStafferName()#<br />
>
> <!--- if it was not a bad read of the address table for the staffer,
> display the address and state --->
> <cfif not badRead>
> <!--- get the address of the staffer from the address table --->
> #staffAddressRecord.getAddress_One()#<br />
> <!--- get the state of the staffer from the address table --->
> #staffAddressRecord.getState()#<br />
> </cfif>
>
> </cfoutput>
>
> --
> <cf_payne />
> http://cfpayne.wordpress.com/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- --
> Reactor for ColdFusion Mailing List
> [email protected]
> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
<cf_payne />
http://cfpayne.wordpress.com/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
