Changing order of recordsets creates non results

Discussion in 'ASP General' started by Aaron Bertrand [SQL Server MVP], Jun 21, 2006.

  1. http://www.aspfaq.com/2188




    "Kevin" <> wrote in message
    news:...
    > Hi,
    > I have used ASP for years using MS Access and have used MSSQL quite a lot
    > as well. I have never came across something like this before.
    >
    > MSSQL table names and types:
    >
    > ProductName nvarchar
    > ShortDescription nText
    > ThumbNail nvarchar
    > etc
    >
    > When I have the recordset in the order as follows, all works well:
    > (Recordset2.Fields.Item("ProductName").Value)
    > (Recordset2.Fields.Item("ShortDescription").Value)
    > (Recordset2.Fields.Item("Thumbnail").Value)
    >
    > Though if I have the Thumbnail first the description does'nt show.
    >
    > Anybody got any ideas on this?
    >
    > Kindest regards,
    > Kevin
    >
    >
    Aaron Bertrand [SQL Server MVP], Jun 21, 2006
    #1
    1. Advertising

  2. Aaron Bertrand [SQL Server MVP]

    Kevin Guest

    Hi,
    I have used ASP for years using MS Access and have used MSSQL quite a lot as
    well. I have never came across something like this before.

    MSSQL table names and types:

    ProductName nvarchar
    ShortDescription nText
    ThumbNail nvarchar
    etc

    When I have the recordset in the order as follows, all works well:
    (Recordset2.Fields.Item("ProductName").Value)
    (Recordset2.Fields.Item("ShortDescription").Value)
    (Recordset2.Fields.Item("Thumbnail").Value)

    Though if I have the Thumbnail first the description does'nt show.

    Anybody got any ideas on this?

    Kindest regards,
    Kevin
    Kevin, Jun 21, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. AFN
    Replies:
    5
    Views:
    400
    dilipdotnet at apdiya.com
    Feb 11, 2004
  2. Sky
    Replies:
    2
    Views:
    354
  3. Larry
    Replies:
    0
    Views:
    181
    Larry
    May 12, 2004
  4. Bob Barrows [MVP]

    Changing order of recordsets creates non results

    Bob Barrows [MVP], Jun 21, 2006, in forum: ASP General
    Replies:
    13
    Views:
    198
    Bob Barrows [MVP]
    Jun 22, 2006
  5. Mark Volkmann

    Struct creates non-standard classes

    Mark Volkmann, Feb 12, 2006, in forum: Ruby
    Replies:
    7
    Views:
    127
    David Vallner
    Feb 13, 2006
Loading...

Share This Page