Reply to thread

Message: [QUOTE="TommyL, post: 6495056"] OK Wake up... Sorry "SELECT DISTINCT Maincategory FROM Results" "Results" being the table.. "Maincategory" the column That should work.... TL | Please could someone take a look at following code .I want it to select | Distinct options but keep on getting multiple of the same selection. | eg: | | Isat | Isat | Isat | Kemco | | The choices are run from a database selection in a dropdown box. | Please could some one help. | Thanks Chris | | Code follows | """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" | """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" | """""""""""""""""""""""""""""""""""""""""" | <html> | | <head> | <% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not | Edit. | FP_CharSet = "windows-1252" | FP_CodePage = 1252 %> | <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> | <title>Sub Search</title> | </head> | | <body bgcolor="#C0C0C0"> | |  | <% if 0 then %> | <SCRIPT Language="JavaScript"> | document.write("<div style='background: yellow; color: black;'>The Database | Results component on this page is unable to display database content. The | page must have a filename ending in '.asp', and the web must be hosted on a | server that supports Active Server Pages.</div>"); | </SCRIPT> | <% end if %> | <% | fp_sQry="SELECT DISTINCT * FROM Results WHERE (Maincategory = | '::Maincategory::') ORDER BY Sublist ASC" | fp_sDefault="Maincategory=" | fp_sNoRecords="No records returned." | fp_sDataConn="Sublisting" | fp_iMaxRecords=256 | fp_iCommandType=1 | fp_iPageSize=0 | fp_fTableFormat=False | fp_fMenuFormat=False | fp_sMenuChoice="" | fp_sMenuValue="" | fp_sColTypes="&ID=3&Maincategory=202&Sublist=202&Remote_computer_name=202&Us | er_name=202&Browser_type=202&Timestamp=135&" | fp_iDisplayCols=1 | fp_fCustomQuery=False | BOTID=0 | fp_iRegion=BOTID | %> |  | <ul> | <li> | <a target="_self" | href="Areaselect.asp?Sublist=<%=FP_FieldURL(fp_rs,"Sublist")%>"> | <%=FP_FieldVal(fp_rs,"Sublist")%></a></li> | </ul> |  |  | | </body> | | </html> | """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" | """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" | """""""""""""""""""""""""""""""""" | | | [/QUOTE]

Verification