> 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.
Just because it's named in the stored procedure doesn't mean that you have to (or can) use named notation to invoke the stored procedure. I don't know how you'd create a parameter in a stored procedure without giving it a name. In the same way, when you write a function in CF or JavaScript, you specify names for your parameters, but when you call the function you can use either positional or named notation. As for Ben's book, I believe that this is an error. It's my understanding that the JDBC drivers shipped with CFMX never supported named notation. I recall several cases where people had to rewrite their CFSTOREDPROC calls to rearrange everything in the right order. 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:258936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
