Now before I do this, based on the information provided by everyone on this list. I want to clarify what I am about to do.
According to Geoff (correct me if I am quoting you wrong), Geoff has stated that the relationship between refObjects and dmArchive with a type of dmArchive is related by objected in both tables. When I was asking the question I had looked at the code and found that the table refObjects table field objecteId is stored inside the dmArchive with the relationship to archiveId field inside that table. Geoff has stated that this is not true, and that the objected in both tables is the relationship. If that is the case why does the code say this, from the code getArchives? <cfscript> sql = "select * from #application.dbowner#dmArchive where archiveID = '#arguments.objectID#' order by datetimecreated DESC"; </cfscript> So I am guessing my intial assumption, is that I can delete any refObject with an objecteId that is stored in the dmArchive table where that objected is equal to archiveId. Not sure why Geoff corrected me on this, but I am asking to make sure what I see and what I am told is in fact different. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. <http://www.aegeon.com.au> www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
