I think Andrew is right here. Actually if you dump a structure and dump a query you will see they are different, queries are almost like a mix of arrays and structures.
But on a side note you can do this using query of queries. Regards Dale Fraser http://dalefraser.blogspot.com -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Friday, 15 June 2007 2:05 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Syntax for StructSort() Ok first of all.. To sort a structure you pass the base of the structure. StructSort( GetUserDetails, "numeric", "ASC", "qUsers.ID" ) The reason you are getting the error, is because you are passing an element of a structure to the StructSort which appears to actually be a query. Which means the function will spit the dummy over it. I have never done this with a query and used a pathToSubelement in the manner I have described above, but my opinion would be to do a QoQ before storing the query into the structure in the first place, doing the sorting with the QoQ if the example above doesn't work. Remember Structures and Queries are not the same type of objects:-) Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Stephen M Sent: Friday, 15 June 2007 1:40 PM To: cfaussie Subject: [cfaussie] Syntax for StructSort() What's the correct syntax for this thing The structure is GetUserDetails.qUsers "ID" is one of the keys, and I just want to sort the structure by ascending ID I've tried StructSort( GetUserDetails.qUsers, "numeric", "ASC", "ID" ) which is exactly what the documentation says. and I've tried StructSort( GetUserDetails.qUsers, "numeric", "ASC", "GetUserDetails.qUsers.ID" ) and StructSort( GetUserDetails.qUsers, "numeric", "ASC", GetUserDetails.qUsers["ID"] ) I fact of tried just about every combination with and without quotes and hashes I just keep getting an empty string error Stephen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
