RE: How can I sort a

[Tim Heald]

You can write something to order the list, but no you can't use a query for
it.  If this pertains to the file view thing from CF-Talk I would recommend
doing it differently.
  -----Original Message-----
  From: Bushy [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 27, 2003 10:18 AM
  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]

---