RE: How can I sort a

[Bushy]

Cool.

I was able to get it to sort using the listsort

<CFSET SESSION.items = LISTAPEEND(SESSION.items,URL.list)>

<CFSET sortedList = ListSort(SESSION.items,"Text","ASC".",")>

Works great.

Thanks

--Original Message Text---
From: Mark Smyth
Date: Thu, 27 Nov 2003 15:43:01 -0000

alternatively and probably far more easier use the listsort() function
http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt220.h
tm#1108087
<http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt220.
htm#1108087>

otherwise if you feel you need arrays use listtoarray() to convert it

-----Original Message-----
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 27 November 2003 15:18
To: CF-Community
Subject: RE: How can I sort a <cfloop results

OK but from your example the QUERY is a table?

So if I have this...

<CFSET SESSION.items = LISTAPPEND(SESSION.items,URL.list)>

SESSION.items =
/temp/dir1,/temp/dir2,/temp/dir3,file1.txt,/temp/dir4,file2.txt

I can do this?

<CFQUERY NAME="test" DBTYPE="query">
SELECT *
FROM '#SESSION.items#'
ORDER BY ??
</CFQUERY>

I'm current;y doing a <CFLOOP> but require a osret function.

<CFLOOP INDEX="i" LIST="#SESSION.items#">
#i#
</CFLOOP>

--Original Message Text---
From: Mark Smyth
Date: Thu, 27 Nov 2003 15:09:48 -0000

you mean

select * from tbl where field = ( '/temp/dir1' or '/temp/dir2'  or ....)
order by ....

if so just loop over the list and manipulate it so it will fit into the
above??

So the answer to your question:
>>Can I do a <CFQUERY on the above SESSION variable and then do a sort ORDER
BY and >>output the results?
is yes

-----Original Message-----
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 27 November 2003 15:00
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]

---