I think that that was what the problem was Russ. I moved the cftry into the query page itself and if there was an error called the same query page from within itself if you see what I mean after changing a variable so that it knows to try a different data type.
Working now. Thanks for the Help Giles ----- Original Message ----- From: "Russ 'Snake' Michaels" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 3:36 PM Subject: RE: [ cf-dev ] CFTRY > there may be an issue with an error occuring inside an included file between > the catch block. Try inserting the code directly and not including it see if > it works. > > -----Original Message----- > From: Giles Roadnight [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 15:34 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] CFTRY > > > 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] > -- ** 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]
