http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T16:52:41 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00000314.htm#65112 It gets worse: when multiple <cfprocresult...> statements are used, maxrows must be specified for every statement if it's used at least once. If you don't specify it for every statement, the same maxrows setting will be used for all result sets. Use maxrows="-1" to force the retrieval of the complete resultset. MU 0 0 2007-04-05T10:52:24 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000314.htm#52909 There is a change in this tag behavior since CF5.<br />If you perform multiple queries in the same store procedures with SQL Server, you may get only the first row in the resultset.<br />In other word RecordCount is not properly instantiated, and if you try to loop the resultset, you may get a wrong result (in my case the first row only).<br />To fix this, I had to set the maxrows parameter to a much higher value than the number of rows expected.<br />Let's hope a patch fix it. gherisson 0 0 2006-09-11T14:31:21