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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
