Hello All, In my search to find out the time difference between OLE and ODBC, i created this little script. I have two simple queries: <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> Then i output the record counts like this: <cfoutput> #FindUsers.recordcount# users found under OLE<br> #FindUsers_odbc.recordcount# users found under ODBC<br> </cfoutput> The first is using SQLOLEDB as its data connection. The second uses ODBC. The issue is that the first query returns only 5 records while the second query returns all 73 records. The table contains 73 records. Does anyone have any ideas as to why this may happen? Do i apply any special settings to permit OLE to retrieve all records? Any light on this issue 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
