ADODB.Recordset returns with incorrect data??

[zymurgy]

I have an ADO.Recordset object that is able to successfully connect to the database and pull data. However, the data that is in the database vs what is being retrieved by the object is incorrect. For example, if I take the exact query that is in the command parameter in the Recordset and execute it in Sql Server Management Studio, the RANK in SSMS is 170 but the data returned in code from the object says it is 140. Has anyone run across a situation like this before? I can't figure out why this is happening. This involves a search box where the user is trying to search for a product and the script is trying to find the product that the user most likely wants to find.

SELECT tbl.RANK as rk, a.*, CA.* FROM FREETEXTTABLE([ab_fts],([cpn],[cd],[mas],[ac],[ttr],[nemo],[man]),'tester',1000) tbl INNER JOIN [qws] a on tbl.[key] = a.wid INNER JOIN catad CA ON (CA.cgid = a.cgid) ORDER BY rk DESC

[zymurgy]

The below code is for the same issue where html stored in the data is being retrieved from SQL Server to build part of the web page. However, the data it is retrieving is old and not what I see when I run the query in SSMS.

Dim FlyoutCheckSQL As String = "SELECT TOP 1 * " & _
                                        "FROM [TopMenu] "
If bEnableGlobalFilter Then FlyoutCheckSQL &= "WHERE [Where] = '" & GlobalWhereClause & "' "
Dim CatalogFlyConn = New ADODB.Connection
CatalogFlyConn.CommandTimeout = 90
CatalogFlyConn.ConnectionString = strConnect
CatalogFlyConn.Open()
FlyoutCheck.Open(FlyoutCheckSQL, CatalogFlyConn, adOpenKeyset, adLockOptimistic)