Jump to content

Jackie

Members
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

Jackie's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Jackie

    Order by record date

    Jackie replied to Jackie's topic in SQL

    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
  2. Jackie

    Order by record date

    Jackie replied to Jackie's topic in SQL

    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
  3. Jackie

    Order by record date

    Jackie posted a topic in SQL

    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?
×
×
  • Create New...