If its in an SP..then simply return the status code. If its in a CF query then you could try a variety of ways....you could select for the record you just created OR in the case of a failure, use cftry/cfcatch in order to trap the error (and subsequent database insert error).
-----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. ======================================================= -- ** 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]
