Named parameters didn't work in CF7. There was a Hotfix that made them work but I don't think it was ever part of the 7.0.1 or 7.0.2 release.
I don't know if it made it into CF 8 or not. Chances are ColdFusion was defaulting to the usual practice of going off the order of the proc param tags. FWIW, running a trace on the database while you made the call would probably have shown the inputs going in the wrong place. ~Brad -----Original Message----- From: Phillip Vector [mailto:[EMAIL PROTECTED] I didn't know that it needs to be the same order. I switched it and it's working now. Thanks. :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:308436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4