Distinct output using ASP/SQL

[bullrider]

I'm having trouble with my output displaying only one link associated with one name. The output currently shows three links for each of the three names and the links are the same for all three. Meaning that each name should only have one associated link. The links are specific to each name. Below is the SQL code followed by an output example:

SQL Code:

Code: Select all

<%
set con = Server.CreateObject("ADODB.Connection")
con.Open "File Name=E:\webservice\Company\Company.UDL"
set rs = Server.CreateObject("ADODB.Recordset")

id=request.querystring("id")

IF id <> "" then id=id else id="9734" end if

'  This will apparently pull back too many records
strSQL = "SELECT DISTINCT GuestName, GuestDescription, URL, Description FROM T_ProgramGuests tpg LEFT JOIN T_ProgramLinks tpl ON tpl.ProgramID = tpg.programID WHERE (tpg.ProgramID = " & id & ")" 

rs.Open strSQL,con

previousGuestName = ""

While Not RS.Eof
    '  Only output guest details if this record has a different guest name to the previous one
    if previousGuestName <> cStr(rs("guestName")) then
        response.write "<br />" & vbcrlf
        response.write "<strong>" & rs("GuestName") & "</strong>"  & rs("GuestDescription") & "<br /><br />Related Links:<br />"  & vbcrlf
        previousGuestName = cStr(rs("guestName"))
    end if

    '  Always output the related links though
    response.write "<li class=""basic""><A HREF=""" & rs("URL") & """>" & rs("Description") & "</A></li>" & vbcrlf
    RS.MoveNext
Wend

recProgram.Close
con.Close
set recProgram = nothing
set con = nothing
%>

Example Output:

Greg Atkinson food writer, chef and regular contributor to the Cooking Klatch

Related Links:
# Brasa
# Greg Atkinson (This is specific to Greg and knowone else)
# Tom Douglas Restaurants

Tamara Murphy executive chef and owner of Brasa

Related Links:
# Brasa (This is specific to Tamara Murphy and knowone else)
# Greg Atkinson
# Tom Douglas Restaurants

Tom Douglas chef and owner of many restaurants around the Seattle area, including Lola, the Dahlia Lounge, Etta's and the Palace Kitchen

Related Links:
# Brasa
# Greg Atkinson
# Tom Douglas Restaurants (Specific to Tom Douglas)

What is wrong with my code that would cause this?