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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download 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:283614 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
