I would have though that you'd know the insert had failed as it would fall over or an error handler would kick in.
However if it's possible that it could be an invalid INSERT ( due to primary key restrictions ), then using a CFTRY and CFCATCH with Exception ANY would handle an error- and if successful, continue noemal templatre processing.... -----Original Message----- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 10:56 To: 'cflist' Subject: [ cf-dev ] Check insert guys..what's the best way to check that a DB insert from a cfm page has been successful? _______________________________________________________<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 _______________________________________________________ ======================================================= This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. ======================================================= DISCLAIMER: This e-mail is confidential and may also be legally privileged. If you are not the intended recipient, use of the information contained in this e-mail (including disclosure, copying or distribution) is prohibited and may be unlawful. Please inform the sender and delete the message immediately from your system. This e-mail is attributed to the sender and may not necessarily reflect the views of the Patsystems Group and no member of the Patsystems Group accepts any liability for any action taken in reliance on the contents of this e-mail (other than where it has a legal or regulatory obligation to do so) or for the consequences of any computer viruses which may have been transmitted by this e-mail. The Patsystems Group comprises Patsystems plc and its subsidiary group of companies. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
