The only fine print I've seen is that the key in the parent table isn't forced to be unique by the engine, but if you're designing foreign keys that aren't this way, then you've got far greater problems.
If there is more fine print, I'd love to hear it, but I've yet to have a problem with using them. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Friday, August 22, 2003 1:43 AM > To: CF-Talk > Subject: Re: MS SQL Server vs. MySQL > > > Barney Boisvert wrote: > > You get foreign key support with innoDB which has been in there > for quite > > some time. > > No you don't. Read the fine print. > > Jochem > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
