My guess would be that the SQL server is not returning in a specified time, might pay to also have a look at the resource monitor and see what is happening, memory wise.
I say this because it might be a case of too much being held in memory at one time! In this scenario, is this a single hit or is this in a production where it's getting a lot of hits!! You might want to look a caching the query, and maybe making it an application scope variable with the proper locks. This would cut the load to the SQL Server it would also mean that less memory would be being used. Just a few thoughts of the top of my head!! -----Original Message----- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 11 December 2001 12:23 PM To: CF-Talk Subject: Re: Help! 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
