Having tried several variations I can't seem to convince Access to delete
from multiple related tables... Is that even possible?
ie:
<cfquery datasource="forum" name="DeleteForum">
DELETE *
FROM
Forums LEFT OUTER JOIN Messages ON Forums.ID=Messages.ForumID
WHERE
Forums.ID=15
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
