This should have been simple as making a PB&J.
I am calling a SP (SQL Server 2005) using the
CFStoredProc function and to get the result set returned as "nextval".
Basically it should return an interget value.
<cfstoredproc
datasource="#application.datasource#" procedure="usp_select_nextval">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="DataTrack_Block">
<cfprocresult name = "nextval">
</cfstoredproc>
Now if I try to use CFDump to
dump the results set "nextval" it indicates the variable does not exist.
What is it I am missing? It has ot be something I can say "DOH" about.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293036
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
