http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T22:51:54 en-us http://livedocs.adobe.com/coldfusion/6/CFML_Reference/Tags-pt39.htm#49711 Hi,<br /> I am using Coldfusion Ver 4.5.2 and found that while using CFSTOREDPROC, all the params in the definition of the Stored Proc must be listed as CFPROCPARAM and also in the same order, else it works unpredictably.<br />The alternative is using cfquery and using parameter=value pairs. 0 0 2006-06-14T08:35:44 http://livedocs.adobe.com/coldfusion/6/CFML_Reference/Tags-pt39.htm#1005 There is no information on the benefits of setting debug="yes". How do I access the information it generates? earnshavian 0 0 2003-04-07T16:12:00 http://livedocs.adobe.com/coldfusion/6/CFML_Reference/Tags-pt39.htm#1003 I find that in CF MX, the CFSTOREDPROC must have a CFPROCPARAM for each and every element that is defined in the procedure that it refers to. Additionally, these CFPROCPARAMs must appear in the same order as the elements in the definition ColdFusion 5.0 did not require this. We have other developers that are migrating from 5.0 to MX, and they don't seem to have this handycap either. What is the truth on the matter? Thanks. luckydoginLR 0 0 2003-03-27T17:18:00