>> trigger or the @@identity value (which I have heard argued >> here is also vulnerable to the same problem as is the MAX >> method, for much the same reasons).
> utter nonsense. I wouldn't know either way, as I don't use SQL server. As I said, I've heard the argument. Nothing more. You know dbs inside and out, Paul. What is your opinion of the best way to accomplish the task, if you're stuck with something like Access or mySQL? What do you think of the CF_max_ID tag the original poster was mentioning? --------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
