Connection Pooling in the Datasource generally returns that error when it expects a different column total. Can you turn off connection pooling for that Datasource?
Thanks! Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 [EMAIL PROTECTED] -----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 12:43 PM To: CF-Talk Subject: Stored Procedure Cached Im using SQL Server 2005 over at Hostmysite I have a stored procedure: <cfstoredproc procedure = "GetFosterFamily" datasource = "#DSN#" username="#dbusername#" password="#dbpassword#"> <cfprocparam type="Out" cfsqltype = "CF_SQL_INTEGER" dbvarname="@ID" value="#URL.ID#" null="no"> <cfprocresult name = "GetContactDetails"> </cfstoredproc> Ive had to make a change in the way the procedure works and it resulted in removing 3 left outer joins (Snoopy Dance) now im getting an error 52>=52 what the heck? from what i can tell the old procedure is being stored somewhere. Rebooting my test server cures the problem, but i cant reboot HMS's server. Any thoughts how i can fix this without renaming my procedure and also renaming it in 40 pages? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 "I think it's T double-E double-R double-R double-I double-F double-I double-C, C, C." - the Goose in 'Charlotte's Web' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
