Tom, One method I have used in the past is when you query the join table and display the results, store the EventJoinID 's in a list hidden form variable. Then on post, wrapped in transaction, a single delete statement using the EventJoinID 's list will delete all of the old records, and then loop over your new joins and insert.
It eliminates the need of worrying if a join was changed or deleted. You can also use <cftry> & <cfcatch> to handle the transaction failing. Dan On 6/3/07, Tom King <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
