Hey Bud, I'm almost certain that's an MDAC-related issue. Do you know the order of installation of CF4.01 and MDAC on the server? I remember CF4.01 was susceptible to this. The MDAC *must* be installed after installing CF.
Also need to check the service packs - I'm presuming it's an NT4 machine, considering the older version of CF? Also update SP for SQL Server if applicable. HTH, Dave -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 08 October 2002 16:21 To: CF-Talk Subject: Anyone seen this error?? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag It is being caused by a simple query: SELECT max(Cust_ID) as maxid FROM Customers The server is CF 4.01 and supposedly the MDAC version is current. I'm waiting on an answer what database is running, but I presume it's Access or SQL Server. The only thing I can see which makes this query different is that the Cust_ID field is text/varchar. But I've run this query forever on 4.0, 4.5, 5 and CFMX without a problem. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
