Professional Web Applications Themes

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

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_na me" 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 ...

  1. #1

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

    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_na me"

    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 Guest

  2. #2

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

    Don't use .Sort

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

    Cheers
    Ken

    "Navin" <navinsm2rediffmail.com> wrote in message
    news:5dc7f532.0309082308.2729d4ecposting.google.c om...
    : 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_na me"
    :
    : 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 Guest

Similar Threads

  1. DataGrid 2 Column Sort
    By Duderr in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: November 15th, 03:06 PM
  2. Sort DataGrid Column
    By mdeaton in forum Macromedia Flex General Discussion
    Replies: 4
    Last Post: November 8th, 10:59 PM
  3. Sort on Date Column
    By Alan Z. Scharf in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: December 5th, 09:38 PM
  4. memory sort and disk sort
    By dusong in forum Informix
    Replies: 4
    Last Post: October 24th, 02:11 PM
  5. How do you sort a 2D array with column headers?
    By Dennis@NoSpam.com in forum PERL Miscellaneous
    Replies: 10
    Last Post: July 1st, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139