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

N

Navin

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
 
K

Ken Schaefer

Don't use .Sort

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

Cheers
Ken

: 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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,733
Messages
2,569,440
Members
44,830
Latest member
ZADIva7383

Latest Threads

Top