Good morning all,
I Created a page that accesses the same database table but with two
different datasources as shown below:
<cfquery name="FindUsers" datasource="facilitadortestsite_ole"
dbtype="OLEDB" debug>
SELECT *
FROM TeaserUsers
</cfquery>
<cfquery name="FindUsers_odbc" datasource="facilitadortestsite"
dbtype="ODBC" debug>
SELECT *
FROM TeaserUsers
</cfquery>
I outputted the total record count for each query in the following way:
<cfoutput>
#FindUsers.recordcount# users found under OLE<br>
#FindUsers_odbc.recordcount# users found under ODBC<br>
</cfoutput>
Here are my results:
5 users found under OLE
76 users found under ODBC
----------------------------------------------------------------------------
----
Queries
FindUsers (Records=5, Time=250ms)
SQL =
SELECT *
FROM TeaserUsers
FindUsers_odbc (Records=76, Time=31ms)
SQL =
SELECT *
FROM TeaserUsers
Why is it that OLE DB is reporting only 5 records, while ODBC is reporting
ALL of them as it should be, based on the query?
Any help will be greatly appreciated!
Andres
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
