it wouldn't just be the dmHTML component - it would have to be every component that can be refered to.
Therefore, following this line of throught, maybe it should be the base component (type?) should have the delete method that removes reference of itself from the relatedID tables.
This is what Paul was suggesting. Any types which have any 'many' properties need to have a delete method defined to ensure referential integrity.
Once you've cleaned up don't forget to call super.delete().
If any core types aren't doing this then we need to file a bug and post a fix.
-- tim lucas
http://www.toolmantim.com
Code snip from my comp:
<!--- clean up any links which don't have categories associated --->
<cfquery datasource="#application.dsn#" name="qDelRefs">
DELETE from #application.dbowner#bosLink_aCategoryIDs
WHERE data = <cfqueryparam value="#stObj.objectid#" cfsqltype="cf_sql_varchar">
</cfquery>
<!--- pass up delete ---> <cfset super.delete(stObj.objectId)>
--- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
