Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Not Displaying redundant recodrs in a recordset

Status
Not open for further replies.

trc

MIS
Nov 27, 2000
126
CA
I have a database with several products that have different versions of the product. What I want is to display only one record for each and have a drop down list for the other types. I am almost there. Well, at least I have something and here it is.

While ((Repeat2__numRows <> 0) AND (NOT rsMultipleProd.EOF))
if ((rsMultipleProd.Fields.Item(&quot;Prodmultiple&quot;).Value)) then
ProdTracker(CheckCounter)=(rsMultipleProd.Fields.Item(&quot;NAME&quot;).Value)
ProdChecker(CheckCounter)=(rsMultipleProd.Fields.Item(&quot;NAME&quot;).Value)
For intOuterCounter = 0 to CheckCounter
If ProdTracker(intOuterCounter) <> (rsMultipleProd.Fields.Item(&quot;NAME&quot;).Value)then
%><br>
<p><b>TRUE</b><br>
<%=(rsMultipleProd.Fields.Item(&quot;NAME&quot;).Value)%><br>
<%=(rsMultipleProd.Fields.Item(&quot;Prodmultiple&quot;).Value)%></p>
<%
End If
Next
CheckCounter = CheckCounter + 1
End if
rsMultipleProd.MoveNext()
Wend


What this does is spit out everything in the recordset. How do I make it work the way I want?
 
Can't you use DISTINCT in your SQL? br
Gerard
 
Thanks. I tried the Distinct and the DistinctRow caluse but it removes all records with the same name. This is sort of what I want. What I want is to display the records with multiple subtypes only once not to remove them totally.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top