Is it returning multiple recordsets perhaps? Or possibly returning a cursor to the recordset?
Judah On Wed, Nov 30, 2011 at 11:18 AM, DURETTE, STEVEN J <[email protected]> wrote: > > Hi all, > > Here is a little background... CF: ColdFusion Server Enterprise 8,0,1,195765 > SQL: Microsoft SQL Server 2008 R2 > > I have a stored procedure that when I run from SSMS it runs perfectly and > returns 2000 rows. When I run it from a cfstoredproc tag it returns no rows > at all. I just changed the cfstoredproc to a cfquery using exec inside the > cfquery and it returned the same 2000 rows. The system is using sql user ids, > and in all three cases the user name and password were exactly the same. > > One other thing, I am using the Fusion Reactor SQL Server driver and the > Fusion Reactor version is 3.5.0. > > Anyone have any ideas why this might happen? > > Steve > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
