Order by record date

[Jackie]

I have a website which we'll call 'Admin' where I can go in as an admin and create records that then display on another website which we'll call 'Groups'. I would like to order my records on the 'Group site' to display the last record I updated as the first record on the page. Is there a SQL statement that I can add in my 'Group' page instead of my Order by group_name or do I have to change it for the 'Admin' site for it to work?

[Siddhesh]

I have a website which we'll call 'Admin' where I can go in as an admin and create records that then display on another website which we'll call 'Groups'.  I would like to order my records on the 'Group site' to display the last record I updated as the first record on the page.  Is there a SQL statement that I can add in my 'Group' page instead of my Order by group_name or do I have to change it for the 'Admin' site for it to work?

<{POST_SNAPBACK}>

You can use SQL statement on ur group page as " Order By Update_Date Desc "

[Jackie]

I got the following error.... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver]

Invalid column name 'Update_Date'. /publicprojects/afs/start.asp, line 102

[Jackie]

Solution:I updated a new column to my database called 'group_order'. Then I did an "Order By group_order" in my 'Group' page and it worked!Thank you for your feedback. It put me on the right track.Jackie