No, it seems that the error message, document position (45:1) to (45:53), is pointing to the offending query. If I comment that query out it no longer causes the error. The query in question is:
<CFQUERY NAME="DistinctHits" DATASOURCE="SonyExcess"> SELECT DISTINCT IncomingIP FROM SiteHits </CFQUERY> Pretty simple. There are about 3,500 records in the table. Eric ----- Original Message ----- From: Garza, Jeff <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 3:11 PM Subject: RE: Help! > You by chance using Query of Queries on that page? > > Jeff Garza > Lead Developer/Webmaster > Spectrum Astro, Inc. > 480.892.8200 > [EMAIL PROTECTED] > http://www.spectrumastro.com > > > > -----Original Message----- > From: ehoma [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 10, 2001 3:52 PM > To: CF-Talk > Subject: Help! > > > Hi, > > Anyone ever seen the following error message? > > > PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (45:1) to (45:53). > > > Our application has been running fine for 3 months and now this occurs on > occasion. Hit refresh on the browser and the page runs fine on the reload. > It is a page with multiple queries. It is the index page that you are > directed to after a login with application, client and session variables > set. > > I'm wondering if it has to do with system resources? > > Any help? > > Thanks, > > Eric Homa > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 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
