Ben's book for CFMX6.0 says that DBVARNAME is required for supporting
named notation.
the variable @user_id is named in the stored procedure.
Scott A. Stewart
REAC/PASS-IT
(202)-475-8875
Dave Watts <[EMAIL PROTECTED]>
11/02/2006 05:31 PM
Please respond to cf-talk
To: CF-Talk <[email protected]>
cc: (bcc: Scott A. Stewart/REAC/HHQ/HUD)
Subject: RE: Stored Procedure oddity
> 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.
It's been a while since I've had to worry about CF 5, but I don't think
that
the DBVARNAME attribute is always required in 5. I know that it's not
supported at all in later releases. In the absence of a name, positional
notation is generally used.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:258935
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
