http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T12:26:38 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-b17.htm#41069 Please take note that there is a _significant_ change in this tag's functionality since CF5 that we just discovered while upgrading to CF7. Previously (in CF5), the above example would work without error. However, in MX and beyond, if there is no result returned by the stored proc, the "RecordCount" attribute of the proc result is undefined and causes an error. In order to fix this, code that used to read:<br /><cfif myResults.recordCount><br />must now read:<br /><cfif isDefined("myResults.recordCount") and myResults.recordCount><br /><br />Obviously, this is annoying and a significant change that should be handled by Macromedia more gracefully. Others are encountering the same problem, as can be seen on this forum thread (to which no Macromedia representative has responded):<br />http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7&threadid=398081&arctab=arc&highlight_key=y&keyword1=CFMX%20CfProcResult<br /><br />Hopefully a patch will arise out of this.<br />Thanks. ujohnc00 0 0 2005-10-19T18:12:24