On 12/1/2011 2:18 AM, DURETTE, STEVEN J wrote: > 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
seen something somewhat similar w/sql server 2008 & datadirect drivers but this was always w/sp that built dynamic SQL (because of a goofy client db schema that i couldn't change). even worse if the sp returned no records, instead of an empty query, it would spit back a NULL. nasty to debug. the same sp worked fine against sql server 2000. if you're using dynamic SQL & different db drivers, i'd maybe blame sql server changes for this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
