This is a multi-part message in MIME format.



------=_NextPart_000_002D_01C18C9A.FB0BEEC0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Experts,



I know that there is probably a simple answer, but how do I do this? I 

have a dynamic select box (code below). It works fine. My Question is, 

how do I make the select box read "Nothing Here" if there are no records 

to retrieve?



Thanks In Advance

John Miller



Code:

<td width=3D"25%" valign=3D"top" align=3D"left"><select 

name=3D"Activity">

<% Do until rsTwo.EOF %>

<option value=3D3D<%=3D rsTwo(1) %>> <%=3DrsTwo(6)%> </option>

<%

rsTwo.MoveNext

Loop

%></select></p></td>

if rsTwo.BOF = true then

    '...no results

else

    Do until rsTwo.EOF %><option value="3D<%= rsTwo(1)

%>"><%=rsTwo(6)%></option><%

       rsTwo.MoveNext

    Loop

end if



tom mallard

seattle

----- Original Message -----

From: "John" <jpmiller@a...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Sent: Monday, December 24, 2001 1:49 PM

Subject: [asp_web_howto] Empty Dynamic Select Box





---

Need a present for your favorite programmer?

E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp

---

Experts,



I know that there is probably a simple answer, but how do I do this? I have

a dynamic select box (code below). It works fine. My Question is, how do I

make the select box read "Nothing Here" if there are no records to retrieve?



Thanks In Advance

John Miller



Code:

<td width="25%" valign="top" align="left"><select name="Activity">

<% Do until rsTwo.EOF %>

<option value=3D<%= rsTwo(1) %>> <%=rsTwo(6)%> </option>

<%

rsTwo.MoveNext

Loop

%></select></p></td>












$subst('Email.Unsub').