Hi all, Last night we finally applied the CFMX7 Updater 2. I know it should have been done a long time ago, but our IT department has a really bad method for requesting patches be applied, have to wait for approval, then I have to do it even though I'm not IT! Anyhow, I noticed something really weird after applying the patch. I have a cfstoredproc that gets two result sets. The code looks something like this: <cfstoredproc datasource="#application.DataSource#" procedure="USP_PULL_DATA"> <cfprocparam cfsqltype="CF_SQL_VARCHAR" value="#Variables.myIdentifier#" dbvarname="@theIdentifier" /> <cfprocresult name="qGetFirstSetOfData" resultset="1" /> <cfprocresult name="qGetSecondSetOfData" maxrows="1" resultset="2" /> </cfstoredproc>
After the updater, this would only return 1 row for the first result set, even though manually running the query returned 15 rows. The correction was to do this: <cfstoredproc datasource="#application.DataSource#" procedure="USP_PULL_DATA"> <cfprocparam cfsqltype="CF_SQL_VARCHAR" value="#Variables.myIdentifier#" dbvarname="@theIdentifier" /> <cfprocresult name="qGetFirstSetOfData" resultset="1" maxrows="50" /> <cfprocresult name="qGetSecondSetOfData" maxrows="1" resultset="2" /> </cfstoredproc> It seems that if maxrows was set for one of them it did it for both. Can anyone confirm this? Thanks, Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
