Let's try this.
I have a SESSION variable that contains a list of files and directories. For example:
<CFSET SESSION.items = LISTAPPEND(SESSION.items,URL.list)>
SESSION.items = /temp/dir1,/temp/dir2,/temp/dir3,file1.txt,/temp/dir4,file2.txt
Can I do a <CFQUERY on the above SESSION variable and then do a sort ORDER BY and output the results?
--Original Message Text---
From: Mark Smyth
Date: Thu, 27 Nov 2003 14:09:44 -0000
<cfoutput>#right("/temp/dir1", 4)#</cfoutput> in the loop will take
"/temp/dir1" and output dir1
you will have to handle #i# if it changes format (as in file2.txt), but you
can use find again to do this
You can also do a query if you need to based on #i# within the loop
hth
Mark
-----Original Message-----
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 27 November 2003 12:26
To: CF-Community
Subject: re: How can I sort a <cfloop results
I have two frames. the top frame display directories/files which the user
can click. When they click on a link the path and filename are sent and
displayed in the bottom frame.
Basically when a link is clicked the <A HREF reloads the bottom frame
displaying the directories/files.
Let's say the SESSION.item variable is equal to
"/temp/dir1,/temp/dir2,/temp/dir3,file1.txt,/temp/dir4,file2.txt"
Currently the above list displays "as-is". How can I sort the above with
directories displaying first?
Can I do a <CFQUERY on the "i" results and then do a ORDER BY somehow?
<CFOUTPUT>
<CFLOOP INDEX="i" LIST="#SESSION.item#>
#i#
</CFLOOP>
</CFOUTPUT>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
