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("Prodmultiple".Value)) then
ProdTracker(CheckCounter)=(rsMultipleProd.Fields.Item("NAME".Value)
ProdChecker(CheckCounter)=(rsMultipleProd.Fields.Item("NAME".Value)
For intOuterCounter = 0 to CheckCounter
If ProdTracker(intOuterCounter) <> (rsMultipleProd.Fields.Item("NAME".Value)then
%><br>
<p><b>TRUE</b><br>
<%=(rsMultipleProd.Fields.Item("NAME".Value)%><br>
<%=(rsMultipleProd.Fields.Item("Prodmultiple".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?
While ((Repeat2__numRows <> 0) AND (NOT rsMultipleProd.EOF))
if ((rsMultipleProd.Fields.Item("Prodmultiple".Value)) then
ProdTracker(CheckCounter)=(rsMultipleProd.Fields.Item("NAME".Value)
ProdChecker(CheckCounter)=(rsMultipleProd.Fields.Item("NAME".Value)
For intOuterCounter = 0 to CheckCounter
If ProdTracker(intOuterCounter) <> (rsMultipleProd.Fields.Item("NAME".Value)then
%><br>
<p><b>TRUE</b><br>
<%=(rsMultipleProd.Fields.Item("NAME".Value)%><br>
<%=(rsMultipleProd.Fields.Item("Prodmultiple".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?