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:348912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
