we have confirmed that the query in Query Analyzer and the data source are pointing to the same database / table there is no limiting attributes with the cfquery tag or in the SQL the missing records depends on the query for example if we order the query differently it will drop any records after 50 records have been returned. I know nothing about how ColdFusion makes the connection to the SQL Server database ie the database driver, but is it possible that a driver would only return 50 records?
On 7/12/07, Dawson, Michael <[EMAIL PROTECTED]> wrote: > > Make sure you are pointing to the same database/table as in Query > Analyzer. > > Make sure you don't have MAXROWS on your CFQUERY tag. > > Are the three missing records "always" the same or are they random? Can > you pinpoint the missing records by comparing the two results? > > M!ke > > -----Original Message----- > From: Bill Fears [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 12, 2007 9:09 AM > To: CF-Talk > Subject: Query Result Problem > > We have a query that returns 53 records in Query Analyzer (which is > correct) but that same query in a CF Page will only return 50 records. > The query is not cached, no maxrows, no TOP keyword and there is nothing > that stands out in CFAdmin. > > Server Specs: > ColdFusion MX 7.0.2 Enterprise, > Windows 2000 , > SQL Server 2000 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
