you tried <CFCatch type="Database"> ?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Giles Roadnight" To: <[EMAIL PROTECTED]> <giles@roadni cc: ght.name> Subject: [ cf-dev ] CFTRY 09/12/02 03:34 PM Please respond to dev Hi, I've not used CFTRY before but I can't see why this doesn't work: <cftry> <cfinclude template="qry_getSearches.cfm"> <cfcatch type="any"> <cfset request.fieldIsNumeric = false> <cfinclude template="qry_getSearches.cfm"> </cfcatch> </cftry> I expect the qry_getSearches.cfm to fail sometimes as I am guessing on of the datatypes in the query. The way I want it to work is if the query fails the field can't be numeric and needs ' ' s around the field value. To do this I set the variable to false and re-run the query, this then adds the ' ' s. However, I get an error from the first query even though it is in a cftry (this cftry is in a nother cftry btw) I know I am getting the error from the first query as I still get it if I comment the second one out. Thanks for your help Giles -- ** 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] -- ** 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]
