Hi Guys!
Has anybody been able to figure out how to get trigger results back through
cfprocs? If I do something like this:
<CFQUERY NAME="MyQuery" DATASOURCE="#MyDSN#" DBTYPE="ODBC">
{ CALL sp_MyStoredProc(#Int(MyInput)#) }
</CFQUERY>
<CFDUMP VAR="#MyQuery#">
The results of whatever triggers run can be seen in the dump - like Audit_ID
will be there if their is some audit trail being run on the table. If I do
something like this:
<CFSTOREDPROC PROCEDURE="sp_MyStoredProc" DATASOURCE="#MyDSN#">
<CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" DBVARNAME="@MyInput"
VALUE="#MyInput#">
</CFSTOREDPROC>
How do I see the results of whatever triggers run? What if I know that
Audit_ID is the name of the field/column? Note that Audit_ID is never
mentioned in sp_MyStoredProc - it's the output of a separate trigger.
Thanx
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
