I have the following code..
<cfinvoke component="FHCcfc.Queries" method="CheckPassword"
returnvariable="Check"></cfinvoke>
in the cfc, I have..
<cffunction name="CheckPassword" returntype="query">
<cfstoredproc procedure="CheckPassword"
dataSource="FoodHandlerCard">
<cfprocparam type="IN" CFSQLType="CF_SQL_VARCHAR"
value="#form.name#" dbVarName="@Name">
<cfprocparam type="IN" CFSQLType="CF_SQL_VARCHAR"
value="#form.password#" dbVarName="@Password">
<cfprocresult name="Check">
</cfstoredproc>
</cffunction>
form.name and form.password are defined and when I put a <cfdump
var="#check#"> before the function ends, I get back a query result. So
I know it's pulling up a query result.
So... Me being new to CFC's, why am I getting the error that it's not
returning a query when it seems to be doing so? I think it's creating
the query in the function, but then it isn't returning back to the
cfinvoke?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308668
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
