logic help needed

[Don Grover]

I have a recordset that returns company names, their are duplicates, sorted
by company name.

sCompanyName = ors("company")

How can I show only one company name from each company and display nothing
for the next name if its the same in the previouse row,

COKE $2.14
$2.16
$2.16
PEPSI $3.13
$3.11
$3.12
FANTA $1.26
$1.26

Regards
Don

[Aaron Bertrand [MVP]]

http://www.aspfaq.com/2241

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

"Don Grover" <spam...@assoft.com.au> wrote in message
news:#D85RFJ3...@TK2MSFTNGP10.phx.gbl...

[Ray at <%=sLocation%>]

Here's one way you can do it:

<%
Dim sOldName, sNewName, sCompanyName
sOldName = ""

Do While Not ors.EOF
sNewName = ors.Fields.Item(0).Value
sCompanyName = sNewName
If sCompanyName = sOldName Then sCompanyName = "&nbsp;"

%>
<tr>
<td><%=sCompanyName%></td>
<td>price code here</td>
</tr>
<%
sOldName = sNewName
ors.MoveNext
Loop

%>

Ray at work

"Don Grover" <spam...@assoft.com.au> wrote in message

news:%23D85RFJ...@TK2MSFTNGP10.phx.gbl...

[Don Grover]

Thanks Aaron and Ray.
Im trying to code with a Migrain at the moment so not working on all
thrusters 8-).

Regards
Don

"Aaron Bertrand [MVP]" <aa...@TRASHaspfaq.com> wrote in message
news:u%238G$HJ3DH...@TK2MSFTNGP12.phx.gbl...