<cfstoredproc procedure="NAME OF STORED PROC"
datasource="ColdFusion Datasource" RETURNCODE="Yes">
<cfprocparam type="In" cfsqltype="VariableType"
dbvarname="Input Param Name from SP" value="#ColdFusion Var Name#" null="No">
<cfprocparam type="In" cfsqltype="VariableType"
dbvarname="Input Param Name from SP" value="#ColdFusion Var Name#" null="No">
<cfprocresult name="Results Set (just like name value
in CFQuery)">
</cfstoredproc>
The returned data would be accessed like this #resultset.fieldname#,
resultset bing the value that you used for cfprocresult
HTH
sas
Scott A. Stewart
REAC/PASS-IT
(202)-475-8875
"Terry Troxel" <[EMAIL PROTECTED]>
11/03/2006 01:03 PM
Please respond to cf-talk
To: CF-Talk <[email protected]>
cc: (bcc: Scott A. Stewart/REAC/HHQ/HUD)
Subject: cfstoredproc
I would really appreciate it if someone could
Show me a simple example of how to use cfstoreproc
With a MSSQL stored procedure and then the code to
Display the results of that.
I have worked with Access for years and am relatively new
To MSSQL and have never used that tag. We have a new
software
In-house that uses MSSQL and the company that wrote it
utilizes
Stored procedures a lot, so I need to get up to speed on
using
CF with it.
Terry Troxel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259118
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
