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]

Reply via email to