Chuck wrote: > I think what you want to do is simply make the cfid column in > both CDATA and CGLOBAL the primary keys for those tables.
On my dev server I have three records in the CDATA file right now: CFID APP DATA ------------------------------ 8:1618725 PI_2k2 (cvars go here) 8:1618725 MYapp (cvars go here) 8:1618725 Test030602 (cvars go here) A primary key on the CFID would limit me to one cfapplication name per server. You have to use a simple index. The way I have mine set up, the CFID fields just get a normal index in both files. I think I could go primary key for CFID in CGLOBAL, but its operated like this for quite some time with no problems. --Matt-- ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
