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 :-) ), 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 !! :-) - Derek -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
