>- see footer for list info -< Morning All, I have built a site using purely stored procedures in an MS SQL 2000 DB (CFMX 6.1 currently but will be porting to V7 when possible). There are instances such as on a registration form where I take information and insert it into 1 table and then put additional information in another table related to the user. For this I am using the @@Identity option within the SP (hope this is the best way to do it). Can I still use CFTransaction around a call to a stored procedure and role back if needed or should this be handled within the SP itself? Should I wrap every call to the DB in CFTry tags and refer out to a standard 'Apologies there appears to be a problem with the systems at present' type page if the connection to the DB fails? If anyone would be interested in trying to break the system as I dare say there will be a number of holes in it that I am not aware of, please let me know your off list details and I will happily contact you (under cover of some NDA I'm afraid). I will be out most of the day so apologies if I do not reply promptly. Regards, Lee _______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
