Cyrill, I think everyone will advise you to always prefer the database
functions--especially when dealing with referential integrity. Databases
have had almost 40 years with some of the best minds applied to them.
They're stable, elegant and fast.
Hal Helms
== See ColdFusionTraining.com for info on "Best Practices with ColdFusion &
Fusebox" training ==
-----Original Message-----
From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 2:49 PM
To: CF-Talk
Subject: Referential Integrity
HI,
My question is whether it is better to write CF routines to maintain
referential integrity of the database (say, hiding a delete button or
checkbox if child records exist in another table) or to set up "Preserve
Referential Integrity" rules in MS access and try to catch errors?
Which leads me to a theoretical question: should I rely more on built-in
database functions or on CF?
Thanks,
Cyrill
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
