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 > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
