I have created a faculty staff directory. Several question have arisen in my mind regarding the data output. Besides the different sorting options, I need help with a filter.
Among other details I am showing "Title", "Department", and "Office". I want to filter out the word "Office" if there isn't a record referenced. My columns are dep_id (Department) and subdep_id (Office). A number is the place holder in the emps table. The deps table has two columns dep_id and name, the subdep table has two columns subdep_id and name. Example: Title: Director Department: Computing Srvs (if no office, don't show anything here) Title: Director Department: Enrollment Srvs Office: Admissions (else show) Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://www.esu.edu <http://www3.esu.edu> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
