RE: How can I sort a

[Mark Smyth]

right i'm with you know, you just want to output the list contents in an
ordered manner.   You could do this programmatically, but really if you need
ordered data use an array instead of a list, arrays are built to manage
ordered data.


You can't do a query, what would you order on even if you could?


hth
mark


-----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]

---