objRS.sort error, Please Help!

Results 1 to 2 of 2

Thread: objRS.sort error, Please Help!

  1. #1
    Join Date
    Dec 1969

    Default objRS.sort error, Please Help!

    I&#039m trying to sort a group of records in a database before I display them, but the objRS.sort function won&#039t work.<BR><BR>Here&#039s the error I get:<BR><BR>ADODB.Recordset error &#039 800a0cb3&#039 <BR>The operation requested by the application is not supported by the provider. <BR><BR>/services/signin.asp, line 122<BR><BR><BR>Here&#039s my open obj string:<BR>objRS.Open "TABLE", objConn, adOpenStatic, adLockOptimistic, adCmdTable<BR><BR>The sort function is set to sort by only one column and in the default ascending way. (objRS.Sort = "COLNAME")<BR><BR>Any ideas as to what the problem might be?<BR>Thanks,<BR>Chris

  2. #2
    Join Date
    Dec 1969

    Default RE: objRS.sort error, Please Help!

    I&#039m not sure about the sort function but have you though of sorting your recordset in your SQL statement? "SELECT * FROM table ORDER BY column"

Posting Permissions

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