query results by date for last 50 results

[fran7]

Hi, I have looked arouind and cannot find a way to query my database by date for the last 50 added results only.
I found this which I suppose might be something similar but I need only the most recent 50 added. That might be the last 10 days or 20 depending how many i add per day.

strSQL = "SELECT * from myTable WHERE [surgeryDate] LIKE ' " & fromDate & " ' " 

the querys I have for all results are like this
lngCategoryID=CLng(Request("CategoryID"))
If lngCategoryID <> "" And lngCategoryID <> 0 Then
 
    Set connPostCardSoft=Server.CreateObject("ADODB.Connection") 
    connPostCardSoft.Open PostCardSoftConnectString
    Set rsCard=Server.CreateObject("ADODB.Recordset")
    rsCard.CursorLocation = 3
    SQLQuery="Select PostCardID,DefaultHeadline,CardDescription,DefaultMessage,extratwo,extrathree,Author,AuthorTwo,NewImageOne,NewImageTwo,NewImageThree,NewImageFour,NewImageFive,NewImageSix,NewImageSeven,NewImageEight,ThumbnailURL,AdvancedCard,BackgroundImageURL,ThumbnailHTML From tblGreetingPostCards Where CategoryID=" & Clng(lngCategoryID) & " Order By BackgroundImageURL DESC"
    rsCard.Open SQLQuery, connPostCardSoft
       rsCard.PageSize = 1000
       intPageCount = rsCard.PageCount
 
       If rsCard.EOF=True Then
        Response.Write "<p>No artists found in database for this category."
        Response.End
    End If
End If

If anyone can help that would be great.
Thanks
Richard

[JamieHowarth0]

Hi Richard,

There's an article on Wikipedia on the SELECT function in SQL, which describes the standard (and non-standard) ways of limiting the number of rows returned from a query (depending on your database engine).
It doesn't go into huge detail on the other parts of a SELECT query but contains all the information you need for your particular requirement.
The link is http://en.wikipedia.org/wiki/Select_(SQL).

Hope this helps.

Best regards,

medicineworker

[fran7]

Dear Medicineman,
Thanks for that really useful link.
Richard