Hi All, Just set up a MySql DB, and I'm trying to work out the best way to update multiple tables via CF:
I.e: TblEvent ------------ EventID [key] EventName tblEventType ------------ EventTypeID [key] EventTypeName tblEventJoin ------------ EventJoinID [key] EventID EventTypeID So above, I might have an EventID, which has multple EventTypeIDs associated with it in tblEventJoin At the moment, the only way I can see of updating the tblEventJoin (assuming I have an EventiD and several EventTypeIDs which are associated) is to Query tblEventJoin, work out whether the Row already exists, if not Insert the record, and if a row exists which shouldnt, delete it. What's the best way to actually do this? Multiple CFQueries, and do the logic CF side, or is there a better method? As you can see, still a newbie on this.. Ta T ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
