on 3/28/01 5:29 PM, Bob Silverberg at [EMAIL PROTECTED] wrote:
> We're on SQL2000, which has it's own quite usable SP debugger. I'm not
> referring to debugging the SPs themselves, which I always do outside of the
> CF environment, but rather debugging problem
One of the things I noticed with using stored procedures is that somehow
it's important that the paramaters that you pass to the stored procedure
from the CF tag be in the same order as they are declared in the MS SQL
stored procedure script. I have spent hours debugging some stored procedure
that was not working and only when I made the order the same between CF and
the stored procedure script did the problem disappear.
Sebastian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
