dmNews, dmEvents, etc. all extend dmTypes, which extends fourQ. There is a method at that level called getMultiple, which will do exactly what you are looking for. Have a look at the 'conditions' argument. It takes a struct to be used in the WHERE filter.
E.g. <cfset stCondition = StructNew() /> <cfset stCondition.departmentID = myProfileCFCPtr.departmentID /> <cfset qNews = cfcNews.getMultipleByQuery( condition = stCondition ) /> Scott Talsma CTO echo.eleven 404.845.3458 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mindmillmedia Sent: Monday, November 27, 2006 4:01 PM To: farcry-dev Subject: [farcry-dev] Custom home.cfc I plan to extend dmProfile, dmHTML, dmNews, and dmEvents and add a "Department" property to each. I want the first page that a user sees when logging in (the one that displays items pending locked, etc...) to display only items from the same department that the user is associated with. After examining home.cfc I cannot determine how to limit the items to only the ones from that department. Any ideas? I understand that I am still a bit new to Farcry...so if there is a better way please let me know. David --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
