From the query I would guess that Pages and PageContent have a hasOne
relationship between them. If that is the case, and assuming that you build
a Pages hasOne PageContent relationship in your config, this is
first-swag-untested-code without referencing any code or docs (read:
double-check my syntax!). It is a rough draft, but it should be close
enough to get you started:
<cfscript>
PagesGateway = application.ReactorFactory.createGateway("Pages");
PagesQuery = PagesGateway.createQuery();
PagesQuery.join("Pages","PageContent","Pages");
Pages.Query.getWhere().isEqual("Pages","page_status",1);
Pages.Query.getWhere().isEqual("PageContent","pagecontent_status",1);
qGetPages = PagesGateway.getByQuery(PagesQuery);
</cfscript>
On 11/25/06, Derek P. <[EMAIL PROTECTED]> wrote:
Hey everyone,
I have a query I wrote that, and I am having a hard time trying to figure
out how to write this in reactor code…heres the query:
SELECT p.page_id, c.pagecontent_id, p.page_name, c.pagecontent_name FROM
pages p JOIN pagecontent c USING (page_id)
WHERE p.page_status = 1 AND c.pagecontent_status = 1
I am not sure the best way to approach the code involved in this (in a
newbie J ), and was hoping that some gracious person might help translate
this to reactor code and give some sort of explanation?
To give you some background, pages is basically the top-level category of
a navigation and pagecontent is the sub-menus of the top-level category…I am
not sure if that's a many to one relationship or what not…any help would be
greatly appreciated !! J
- Derek
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com
Where's your Spot?
www.instantspot.com
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
