> bottom line is that it is a pain in the keester to make a DB portable with > identity fields as a PK
That hasn't been my experience. Not only does every database I've used in the past several years support an Auto Number/Identity field, but most provide a way to override the Identity field to allow insertion of user-defined identities (e.g. importing data from another database). Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
