Do Until loop with IF

crmpicco · June 15th, 2005, 05:36 AM

Code:

<%
Do Until rst1.EOF 
if trim(rst1("company_name")) = trim(rscompany("company_name")) then
response.write ""
else
%>
<option value="<%=trim(rst1("agencyid"))%>"><%=trim(rst1("company_name"))%></option>
<%
end if
rst1.movenext
loop
%>

I have this structure for a drop-down menu. Basically, i dont want to show one result of the loop. how can i do this?

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

crmpicco · June 15th, 2005, 05:37 AM

Oh, BTW, rscompany is here :

Code:

if nomore_agency then 
theagencyid = request.querystring("theagencyid")
set rscompany = con.execute("select company_name from company where agencyid = '"&theagencyid&"'")
end if

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

happygv · June 15th, 2005, 05:35 PM

Code:

<%if trim(rst1("company_name")) <> trim(rscompany("company_name")) then %>
    <option value="<%=trim(rst1("agencyid"))%>"><%=trim(rst1("company_name"))%></option>
<%end if%>

Is this what you are looking for?

_________________________
- Vijay G
Strive for Perfection