I'm using a query string value in the SQL statement so that if a person wants to reorder the results on the page they can:
sqlString = "SELECT * FROM guestbook ORDER BY " & sortBy
I've tried this to resort the results:
sqlString = "SELECT * FROM guestbook ORDER BY '" & sortBy & "' DESC "
This just srews up the order completely.
How can I change the order from oldest to newest first? One other thing is that the date I pull out of the database is in the wrong format. Is there away of changing the format of the date to the way we have it in the UK? at the moment its mm/dd/yyyy but it should be dd/mm/yyyy