As far as my experience calling MS SQL 2000 stored procs, the order of the inputs is all that matters-- the name I provide in the ColdFusion call is completely arbitrary.
This could really screw things up when a DB person added a new input to an existing proc in the middle of the parameter list without telling the CF people. :) ~Brad 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
