I've always found their support to be top notch. I would contact them and explain the situation. They'll probably be able to help you out rather quickly.
-----Original Message----- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 12:57 PM To: CF-Talk Subject: Re: Stored Procedure Cached Its Hostmysite.com's server so no. On 10/4/06, Christine Davis <[EMAIL PROTECTED]> wrote: > > 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:255505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
