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:255473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
