order by date

Results 1 to 3 of 3

Thread: order by date

  1. #1
    krane Guest

    Default order by date

    sql= "SELECT Frase, Data, Inserido FROM " & Request.Querystring("Sc") & ";" Order by Date<BR>rst_DB.Open sql, con_DB<BR><BR>this is not working :( i can&#039;t put any order on that :&#124 without the order it works fine. can anyone help me?! <BR>tks

  2. #2
    Join Date
    Dec 1969

    Default Hate to ask

    but I assume you have a field in your db labeled Date?

  3. #3
    K. Guest

    Default RE: order by date

    Your SQL statement looks a little strange to me (a semicolon indicates the end of your SQL statement so your order by clause wouldn&#039;t be interpreted...then again, I use T-SQL for SQL Server. One thing I can see right off the top is that when you name a field "date" in a table you have to reference it like this [Date].<BR>SQL = "SELECT Frase, Data, Inserido FROM &#039;"&Request.Querystring("Sc") &"&#039; ORDER BY [Date]"<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts