I have an event calendar access database with two tables (one called category with two fields: "cat_no" and "descr".. the other table is called events with many fields including two called "category" and "category2") . Events can have one or two categories and each event should be reflected on one row of the table with description, location etc. The event_no is unique for each event The Table displays as shown below, but for example event# 128 should only come up on one row with Fine Food & Beverage; Arts, Theatre & Concerts shown under Category Description.... what's wrong with my code below ?? Event no. Category Description Location Category Category2 (Events Table) (category table) (events table) (category table) (Category table)
128 Fine Food & Beverage; St Michaels; 1 5 126 Sports - Youth; St Michaels; 1 2 128 Arts, Theatre & Concerts; St Michaels; 1 5 126 Arts, Theatre & Concerts; St Michaels; 1 2 <cfquery datasource="cal_endar_2" name="findcal"> SELECT * FROM events e, category c where e.category=c.cat_no or e.category2=c.cat_no </cfquery> <table> <cfoutput query="findcal" group="event_no"> <tr> <td valign="top">#event_no#</td> <td><cfoutput>#descr#;</cfoutput></td> <td>#town#</td> <td>#category#</td> <td>#category2#</td> </tr> </cfoutput> </table> Thanks in Advance ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
