Anyone want to take a shot at why this query throws a PCCode error
every once in a while? CF5...
<cftry>
<cfquery name="qry_prod" datasource="#variables.dsn#" cachedafter="01/01/01">
select *, lower(keywords) as l_keywords
from v_products
where WebStoreID = #request.webStoreID#
</cfquery>
<cfcatch type="Any">
<cflock type="EXCLUSIVE" scope="APPLICATION" timeout="5"
throwontimeout="No">
<!--- Reset cache timer --->
<cfset application.nextupdate = dateadd('n',1,now())>
</cflock>
<cfoutput>An unexpected error has occurred.<br>Please try again in a
few minutes.</cfoutput>
<cfabort>
</cfcatch>
</cftry>
--
jon
mailto:[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
