Sort a Query Descending

  • Thread starter Thread starter raul
  • Start date Start date
R

raul

Hi

I have a OU with 100.000 objects, and I have a query with ASP. The
problem is that when I like to present the query descending by fechaUpload
(for example), Active doesn't order it, but order it in ascending mode.

The code is the following one:

oCommand.properties("size limit")=100
oCommand.properties("sort on")=" fechaUpload"

LDAPQuery="LDAP://10.100.111.28/OU=documentos,DC=aspdocxier,DC=i2000,DC=es"
oCommand.CommandText="select familia, categoria, subcategoria, fechaupload,
numVersiondoc, pathFTP from '" &LDAPQuery& "' where objectClass='doc' and
familia='scanx' "

Thanks.

Raul.
 
See http://support.microsoft.com/?id=263928if it helps. I know there are
quite some problems with ADSI sorting as it does not supports ORDER BY in
SQL dialect (documentation states otherwise). In the worst case you have to
write your own sort procedure. Richard Muller has one somewhere.

--
Regards

Matjaz Ladava, MCSE, MCSA, MVP
Microsoft MVP - Active Directory
(e-mail address removed), (e-mail address removed)
http://ladava.com
 
Back
Top