Ok...another question - btw thanks to all for your help
Now, if I want to use the same recordset object - re open it with a different query each time...do I need to set it to nothing before re-opening it?? I know I need to at least close it first...but something still isn't working. Every time I try to run the code the page gets "stuck", it won't finish loading.
Here's the relevant portion of my code:
<%
Dim rs
Set rs = Server.CreateObject("ADODB.RecordSet"

Dim strItem
sSqlString = "SELECT * FROM itemlist WHERE category = 'apparel'"
rs.Open sSqlString, oConnection, 0
Do While NOT rs.EOF
strItem = rs("item"

%>
<option><%=strItem%></option>
<%
rs.MoveNext
Loop
rs.Close
%>
...some more html, then:
<%
sSqlString = "SELECT * FROM itemlist WHERE category = 'miscellaneous'"
rs.Open sSqlString, oConnection, 0
Do While NOT rs.EOF
strItem = rs("item"

%>
<option><%=strItem%></option>
<%
Loop
rs.MoveNext
rs.Close
%>