-----Original Message-----
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 27, 2003 10:00 AM
To: CF-Community
Subject: RE: How can I sort a <cfloop results
Maybe I didn't explain it properly.
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]
