John, I believe the problem is almost certainly related to unlocked memory scoped variables such as the session. one shown here. What you need to do is lock all writes and reads of any application. server. and session. scoped variables using cflock.
Mike Brunt Sempra Energy 213.244.5226 "To define recursion, we must first define recursion." -----Original Message----- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 6:02 PM To: CF-Talk Subject: how might I reolve a pcode error? Hi all I'm experiencing the following error: = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (4:1) to (4:71) in the template file C:\WEB_PAGES\THEMACHINERYWORKS\CART\TAG_GO_CUSTOMERS_B2S2.cfm. = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = It occurs whenever I attempt to execute this query: <cfquery datasource="#SESSION.dsn#" name="CALLER.tag_go_customer_b2s2"> SELECT (name10, name_20) FROM cart_customers WHERE customer_UUID = '#ATTRIBUTES.customer_UUID#' </cfquery> The odd thing is if I only select one column, I don't see the pcode error. Also, if I run a joined query, it doesn't bomb either. I read up a little and says that one of the causes might be installing SQL 7. Installed that about a year ago and this is the first time I've run into this error. Other sites and webapps I've running on my dev box are still working ok. Also, this error only seems to affect queries where I'm retrieving data from the database. What do I need to do to resolve this? Thanks in advance. * John * ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
