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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
