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]
