Hi.

I have a code to loop data into a puldown box. can not figure out why in the world the results are appearing TWICE for every row!

Code:
<%
LETTER = request.querystring("LETTER")


SQL ="SELECT at_access.user_ID, customer.custcode, customer.custname FROM customer, at_access WHERE customer.custcode LIKE '" & LETTER & "%'"
Rs.Open sql, Conn

%>



        <table border="0" cellspacing="0" cellpadding="10" align="center">
                <tr>
                <td align="center" colspan="2" class="subhead">

<form action="myaccount/oddlist_ataccess/oddlist_ataccess.asp?search=" method="get">
<input type="hidden" name="repcode" value="<%= Rs("user_ID") %>">

<%
                If LETTER < "0" Then
            %>
<b>EXCESS INVENTORY BARGAINS:
</b><BR>
<b>Please Select A Letter For A Customer!
</b>
            <% Else %>
<b>EXCESS INVENTORY BARGAINS:
</b><BR>
<select NAME="Search">
    <%
    Do While Not rs.EOF
        %>

            <OPTION value='<%=Rs("custcode")%>'> <%=Rs("custcode")%> = <%=Rs("custname")%></OPTION>
<% rs.MoveNext
loop
%>
</select>
<BR><BR>
<input TYPE="submit" VALUE="Excess Inventory Bargains" style="width: 300px">
</form>

</td>
</tr>
</table>
<%
end if
conn.close
%>

all my customers are getting listed TWICE:

SSKEMP
SSKEMP
IFED
IFED
PLUMBINGSUPPLY
PLUMBINGSUPPLY

ETC...

database is perfect. No doubles. any clue?

Your sql statement is pulling data from two tables...you are probably missing another join condition in your where statement...to eliminate duplicate data.

Have you tried running your sql statement in sql query analyzer...to see if your results contain two rows (if so then you know its not a problem with your asp code)

http://mynameissteve.com

Hi Melkin!!

Your asp code is fine,only problem is with the query
SQL ="SELECT at_access.user_ID, customer.custcode, customer.custname FROM customer, at_access WHERE customer.custcode LIKE '" & LETTER & "%'"

Reason-ur qury is cross join,so resulting multiple results
 use inner join
Hope this will help you


Cheers :)

vinod