469,645 Members | 1,653 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

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
Jul 19 '05 #1
1 3980
Don't use .Sort

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

Cheers
Ken

"Navin" <na******@rediffmail.com> wrote in message
news:5d**************************@posting.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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Java and Swing | last post: by
3 posts views Thread by Bob Dankert | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.