2. ASPRunnerPro General questions
  3. How to change list order
This topic is locked

How to change list order

 		9/16/2009 8:29:58 PM
ASPRunnerPro General questions
R
 racheleyes author

Hello,
i have created a small site using the classifieds template and so far it's going ok. However i would like to change the order in which items are listed. Currently it is listed with the oldest item on top. Something like this:
13/09/2009 product info

14/09/2009 product info

15/09/2009 product info

16/09/2009 product info
I would like to change it so that the oldest items are at the bottom of the page and the newest are on top like so:
16/09/2009 product info

15/09/2009 product info

14/09/2009 product info

13/09/2009 product info
How do i do this? is there a way of doing this without re-creating the entire project using asprunner?
Thanks.
J
 		Jane 9/17/2009

Hi,
to change records order edit SQL query on the Edit SQL query tab.

Here is a sample:

select Field1,

Field2,

DateField

from TableName

order by DateField desc
R
 		racheleyes author 9/17/2009



Hi,
to change records order edit SQL query on the Edit SQL query tab.

Here is a sample:

select Field1,

Field2,

DateField

from TableName

order by DateField desc



Thanks for your reply.
Is there a way for me to change the order without re-building the website (i.e by changing some of the coding on the already completed website)? It's just that i've spent a while on it so far and would like to avoid starting from scratch if possible.
Thanks
R
 		racheleyes author 9/19/2009



Hi,
to change records order edit SQL query on the Edit SQL query tab.

Here is a sample:

select Field1,

Field2,

DateField

from TableName

order by DateField desc



Thanks for the info. I did as you said and its now fixed.
Thanks.