You can of course order a query, using ORDER BY in the sql. If you don't have a column to sort by already, you can add one to your QueryNew() function and set the value (perhaps the index of your loop?) with QuerySetCell()
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Daniel Short Sent: Monday, February 28, 2005 4:42 PM To: [email protected] Subject: RE: [CFCDev] Using Structures to handle navigation (order problems) I'll have to give that query trick a try. I'm assuming that a query remembers it's order based on the order rows are inserted? Dan > You've got to use the 4 query-creation functions: > QueryNew, QueryAddColumn, QueryAddRow, QuerySetCell ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
