Thanks for the help with the last stored proc ... the advice helped.
Now I'm having another error I don't understand.
My stored proc establishes this output variable:
@STORY ntext OUTPUT
My cfstoredproc tag includes:
<cfprocparam type="Out"
cfsqltype="CF_SQL_longvarchar"
dbvarname="STORY"
variable="STORY"
null="NO"> (also tried "yes")
My error is this:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure
'arc_find_detail_story' expects parameter '@STORY', which was not supplied.
Sure looks like I'm supplying the parameter to me ...
H.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
