Unwanted repeating data elements in table

You couldn't be more correct. I ran query analyzer and sure enough, there were dups in there. I forgot to drop the existing table and re-create the new table.

Thanks for the quick response and help! I hope I have a chance to do the same.

Harry

 

I developed an e-Commerce application and when I run it on my localhost machine, I get a list of products. The list should have one and only one of each product.

However, when I upload my project to your server and run it, the datalist gives me dulipcates everytime. I deleted and re-uploaded and still the same results.

My question, why is it that I am getting dupicate results on the server version? This is an undesirable result.

Links:
Notice here the duplicate list of products...
http://www.harryteck.com/OnlineStore2/Category.aspx?cat=4

Notice here the same on a different page...
http://www.harryteck.com/OnlineStore2/Products.aspx?pid=37

Here is the table output of how it looks on my localhost without the duplicates:
<table id="dlstProducts" cellspacing="9" cellpadding="20" border="0">
<tr> <td style="font-family:Comic Sans MS;">
<img src='images/caramels.jpg'>

<a href="Products.aspx?pid=33">Caramels</a>
</td><td style="font-family:Comic Sans MS;">
<img src='images/caramelnut.jpg'>

<a href="Products.aspx?pid=37">Caramel Nut Clusters</a> </td> </tr>
</tbale>

Here is the table output of how it looks on the server with duplicates. Notice the duplicate pid's:

<table id="dlstProducts" cellspacing="9" cellpadding="20" border="0">
<tr> <td style="font-family:Comic Sans MS;">
<img src='images/caramels.jpg'>

<a href="Products.aspx?pid=33">Caramels</a>
</td><td style="font-family:Comic Sans MS;">
<img src='images/caramels.jpg'>

<a href="Products.aspx?pid=33">Caramels</a>
</td><td style="font-family:Comic Sans MS;">
<img src='images/caramelnut.jpg'>

<a href="Products.aspx?pid=37">Caramel Nut Clusters</a> </td>
</tr><tr> <td style="font-family:Comic Sans MS;">
<img src='images/caramelnut.jpg'>

<a href="Products.aspx?pid=37">Caramel Nut Clusters</a> </td> </tr>
</table>

Thanks,
Harry

 

Maybe a silly question, but are you sure that there are no duplicates in your database ? Or that your query is the same as in your local database ?

--
Steurm
www.steurm.net/steurm