If i have different titles in my database and in each of those titles there are many parts.<BR><BR>How can i list the parts that belong to its title.<BR><BR>it is liek a relate stories. please help. thanks
sSQL = "SELECT FieldA, FieldB, FieldC " & _<BR> "FROM TheTable "<BR> "WHERE TheTitle = '" & theTitle & "'"<BR><BR>Something to that affect should work for you. You might also be able to do it all in a single statement, doing a join and then making your display code only show the unique titles and having it list the parts (see FAQ #154 -- http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=154).