what error are you getting back?
At 15:34 12/09/02 +0100, you wrote: >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]
