Yes - this is a connection-wide directive. The solution would be to find the query that's setting it to 50, and either change it to use "TOP" in the select statement, or make sure to add the SET ROWCOUNT 0 after it.
On 7/13/07, Bill Fears <[EMAIL PROTECTED]> wrote: > > that seams to have worked for that query, but other queries still return a > limit of 50 records. So I have this question, that I could not answer > myself > with a google search... Is possible that a SET ROWCOUNT x in one place > would > affect every query from that server? > > On 7/12/07, Doug Bezona <[EMAIL PROTECTED]> wrote: > > > > Shot in the dark here, but is there a query anywhere in your > application, > > or > > otherwise being executed against your database, that is using SET > ROWCOUNT > > 50, and not resetting the rowcount attribute to 0 afterwards? > > > > On 7/12/07, Bill Fears <[EMAIL PROTECTED]> wrote: > > > > > > we restarted the coldfusion server and we got the full record set for > > > about > > > 10 queries it's every other one ie 50 records then full set then back > to > > > 50 > > > intermittently and randomly. This makes no sense at all???? > > > > > > On 7/12/07, Brad Wood <[EMAIL PROTECTED]> wrote: > > > > > > > > When using the JDBC url wrapper for SeeFusion, you can specify a > > > > rowLimit and it won't return any more than that many records. > > > > See http://www.seefusion.com/index.cfm?do=c_faq.technical#10 > > > > > > > > How does the rowLimit feature work? > > > > The rowLimit feature is new to SeeFusion 3.1, and it allows you to > set > > a > > > > limit for the number of records returned by any datasource that is > > > > wrapped by the SeeFusion JDBC driver. The limit is set by adding, > for > > > > example, ";rowLimit=1500" to the end of the SeeFusion JDBC URL in > > > > ColdFusion Administrator. In this example, any query using that > > > > SeeFusion-wrapped datasource name would stop executing after the > > result > > > > set reached 1500 records. > > > > > > > > -----Original Message----- > > > > From: Bill Fears [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, July 12, 2007 11:57 AM > > > > To: CF-Talk > > > > Subject: Re: Query Result Problem > > > > > > > > yes we are using SeeFusion, I'm interested in what you might think > is > > > > going. > > > > > > > > On 7/12/07, Brad Wood <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Are you using any monitoring product like SeeFusion which might be > > > > > limiting the number of records? > > > > > > > > > > ~Brad > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
