> 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>
Maybe it has to do with the caching? I've occasionally seen some weird errors relating to query caching. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
