Ado sort error-Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose k

Discussion in 'ASP General' started by Navin, Sep 9, 2003.

  1. Navin

    Navin Guest

    Ado Sort -Relate, Compute By, or Sort operations cannot be done on
    column(s) whose key length is unknown or exceeds 10 KB.

    hi,
    guys
    i have asp application running on iis 5.0 windows 2000
    i use the ado sort property ......
    shown below....

    Rs.sort="person,lower_manager,lower_ccat_id,sac_name"

    i get the following error..

    Microsoft Cursor Engine (0x80004005)
    Relate, Compute By, or Sort operations cannot be done on column(s)
    whose key length is unknown or exceeds 10 KB.


    if give only a single column in the sort property it works fine....
    Rs.sort="sac_name"

    can brillant minds advise where the problem..............lies..
    tried at microsoft site but no clues..

    regds,
    Navin Mahindroo
     
    Navin, Sep 9, 2003
    #1
    1. Advertising

  2. Navin

    Ken Schaefer Guest

    Don't use .Sort

    Use an SQL statement, and use the ORDER BY clause instead.

    Cheers
    Ken

    "Navin" <> wrote in message
    news:...
    : Ado Sort -Relate, Compute By, or Sort operations cannot be done on
    : column(s) whose key length is unknown or exceeds 10 KB.
    :
    : hi,
    : guys
    : i have asp application running on iis 5.0 windows 2000
    : i use the ado sort property ......
    : shown below....
    :
    : Rs.sort="person,lower_manager,lower_ccat_id,sac_name"
    :
    : i get the following error..
    :
    : Microsoft Cursor Engine (0x80004005)
    : Relate, Compute By, or Sort operations cannot be done on column(s)
    : whose key length is unknown or exceeds 10 KB.
    :
    :
    : if give only a single column in the sort property it works fine....
    : Rs.sort="sac_name"
    :
    : can brillant minds advise where the problem..............lies..
    : tried at microsoft site but no clues..
    :
    : regds,
    : Navin Mahindroo
     
    Ken Schaefer, Sep 9, 2003
    #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. keithb
    Replies:
    1
    Views:
    2,786
    Teemu Keiski
    Apr 8, 2006
  2. Jerry
    Replies:
    10
    Views:
    530
  3. gnewsgroup
    Replies:
    4
    Views:
    9,048
    bigal
    May 21, 2008
  4. Nathan Rice
    Replies:
    0
    Views:
    179
    Nathan Rice
    Jan 16, 2012
  5. PerlFAQ Server
    Replies:
    0
    Views:
    287
    PerlFAQ Server
    Feb 2, 2011
Loading...

Share This Page