RE: Desc Output
or do a query of a query and choose your order clause in it. That way you could still use cfoutput and groupby if needed. > -Original Message- > From: Pascal Peters [mailto:[EMAIL PROTECTED] > Sent: Friday, August 06, 2004 10:54 AM > To: CF-Talk > Subject: RE: Desc Output > > > #query.field[i]# > > > Pascal > > > -Original Message- > > From: Shahzad.Butt [mailto:[EMAIL PROTECTED] > > Sent: 06 August 2004 17:51 > > To: CF-Talk > > Subject: Desc Output > > > > > > > > How can I output the results of the query starting from last record > > found by query and finishing at starting record found? Can't change > the > > Order by from Desc to Asc in the query because of loads of reasons. > > > > > > > > > > > > Thanks > > > > Shaz > > > > > > > > ** > > This email and any files transmitted with it are confidential > > and intended solely for use by the individual or entity to > > whom it is addressed. If you have received this e-mail in > > error, kindly notify [EMAIL PROTECTED] or call > > +44 1992 701 704. Unless stated otherwise, please note > > that any views or opinions expressed in this e-mail are solely > > that of the author and are not necessarily of > > JJ Fast Food Distribution Limited. The company can not > > assure that the integrity of this communication has been > > maintained nor that it is free of errors, virus, interception or > > interference. The company accepts no liability for any > > damage caused by this email. JJ Fast Food Distribution > > Limited reserves the right to monitor and or record e-mail > > without prior notification. > > ** > > > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Desc Output
Or you can do a query of query, and change the sort order on your result set... Shawn -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Friday, August 06, 2004 9:57 AM To: CF-Talk Subject: Re: Desc Output If you can't do it in the query, there are ways to do it in CF. Probably the easiest/best way I can think of in the 30 seconds of thought I've given it is for something like this: #yourQuery.yourColumn[i]# Scott - Original Message - From: Shahzad.Butt How can I output the results of the query starting from last record found by query and finishing at starting record found? Can't change the Order by from Desc to Asc in the query because of loads of reasons. -- - Scott Brady http://www.scottbrady.net/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Desc Output
If you can't do it in the query, there are ways to do it in CF. Probably the easiest/best way I can think of in the 30 seconds of thought I've given it is for something like this: #yourQuery.yourColumn[i]# Scott - Original Message - From: Shahzad.Butt How can I output the results of the query starting from last record found by query and finishing at starting record found? Can't change the Order by from Desc to Asc in the query because of loads of reasons. -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Desc Output
#query.field[i]# Pascal > -Original Message- > From: Shahzad.Butt [mailto:[EMAIL PROTECTED] > Sent: 06 August 2004 17:51 > To: CF-Talk > Subject: Desc Output > > > > How can I output the results of the query starting from last record > found by query and finishing at starting record found? Can't change the > Order by from Desc to Asc in the query because of loads of reasons. > > > > > > Thanks > > Shaz > > > > ** > This email and any files transmitted with it are confidential > and intended solely for use by the individual or entity to > whom it is addressed. If you have received this e-mail in > error, kindly notify [EMAIL PROTECTED] or call > +44 1992 701 704. Unless stated otherwise, please note > that any views or opinions expressed in this e-mail are solely > that of the author and are not necessarily of > JJ Fast Food Distribution Limited. The company can not > assure that the integrity of this communication has been > maintained nor that it is free of errors, virus, interception or > interference. The company accepts no liability for any > damage caused by this email. JJ Fast Food Distribution > Limited reserves the right to monitor and or record e-mail > without prior notification. > ** > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]