<CFSTOREDPROC PROCEDURE="chk_org_by_inspector" DATASOURCE="#app_datasource#"
RETURNCODE="Yes">
<CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_VARCHAR"
VALUE="#cookie.userid#" NULL="No">
<CFPROCRESULT NAME="get_inspector_org">
</CFSTOREDPROC>
<CFIF cfstoredproc.statusCode IS NOT 0>
A database error occured.
<CFABORT>
</CFIF>
<cfif get_inspector_org.recordcount eq 0>
<cfoutput><h2>You do not have the necessary rights to access this
page.</h2></cfoutput>
<cfabort>
<cfelse>
Stuff that shouldn't run if either of the two cfif statements is
true
</cfif>
I'm trying to fix an existing app in CF5.0
if you look at the above code you'll see that the CFPROCPARAM is missing
the DBVARNAME parameter. I don't know how it got passed the CFDebugger
into our production environment
but it did.
What would the CFSTOREDPROC return? I have the feeling that it wouldn't
return anything because the procedure would never run, thus the next two
cfif statements would be false
thoughts
Scott A. Stewart
REAC/PASS-IT
(202)-475-8875
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:258926
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
