http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T04:40:38 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/funca104.htm#38260 Helped me! Thanks. mowebdev 0 0 2005-08-02T12:13:46 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/funca104.htm#33194 Its ok as i sorted it using the following<br /><br /><cfset directoryQuery = QueryNew("FirstName,LastName,Service,Department,ext")><br /><br /><cfoutput query="rs_searchResults"><br /><br /> <cfset service = getToken(distinguishedName,3,",")><br /> <cfset service = trim(getToken(service,2,"="))><br /><br /> <cfif not findnocase(service,bannedlist)><br /> <cfscript><br /> newRow = QueryAddRow(directoryQuery);<br /> QuerySetCell(directoryQuery, "FirstName","#rs_searchResults.givenname#" );<br /> QuerySetCell(directoryQuery, "LastName", "#rs_searchResults.sn#" );<br /> QuerySetCell(directoryQuery, "Service","#service#" );<br /> QuerySetCell(directoryQuery, "department","#rs_searchResults.department#" );<br /> QuerySetCell(directoryQuery, "ext","#replacenocase(rs_searchResults.telephonenumber,' ','','all')#" ); <br /> </cfscript> <br /> </cfif><br /></cfoutput><br /><br /><cfquery dbtype="query" name="sorted"><br /> SELECT * <br /> FROM directoryQuery <br /> ORDER BY service, department, lastname, firstname<br /></cfquery><br /><br />As you can see i was trying to sort active directory. CFLDAP couldnt do it for me. Hope this helps others as it certainly helped me Martyn Hills 0 0 2005-05-10T03:41:11 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/funca104.htm#33193 I have a 2d structure to contain user information but how do i order the entire list by an element in the structure??<br /><br />Here is what im storing with examples<br /><br />name : John Smith<br />service : development<br />department : beer development<br /><br />How would i sort my structure by service, department then by name??<br /><br />Any help would be great as its driving me mad!!!!!! Martyn Hills 0 0 2005-05-10T03:17:11 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/funca104.htm#32591 to get a list sorted based on the structure key values you can do the following:<br /><br /><cfset temp = ListSort(StructKeyList(myStruct), "text")> OneTruth 0 0 2005-04-28T11:06:41 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/funca104.htm#27390 How would you sort the values in a Structure in alphabetical order based upon the Key? Is it possible? Something like this?<br /><br /><cfset Values = structNew()><br />....................<br /><!--- code to enter values into the structure---><br />....................<br /> <cfset temp = StructSort( values, "text", "ASC", Key )><br /><br />Thanks for your help ahead of time! jce1975 0 0 2005-02-03T11:47:02 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/funca104.htm#1224 The most powerfull feature of structures is, For example you have one structure which would hold other structure values as well. and we can split the structure up to single numeric or text value for sorting the structure . sanaullah 0 0 2003-08-08T08:25:28