User Profile

Collapse

Profile Sidebar

Collapse
zymurgy
zymurgy
Last Activity: Apr 20 '15, 05:37 PM
Joined: Apr 20 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • zymurgy
    replied to ADODB.Recordset returns with incorrect data??
    in Visual Basic
    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.

    Code:
    Dim FlyoutCheckSQL As String = "SELECT TOP 1 * " & _
                                        "FROM [TopMenu] "
If bEnableGlobalFilter Then FlyoutCheckSQL &= "WHERE
    ...
    See more | Go to post
    Last edited by Rabbit; Apr 20 '15, 05:54 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.

      Leave a comment:

    • zymurgy
      started a topic ADODB.Recordset returns with incorrect data??
      in Visual Basic

      ADODB.Recordset returns with incorrect data??

      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...
      See more | Go to post
      Last edited by Rabbit; Apr 20 '15, 05:54 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
      No activity results to display
      Show More
      Working...