| <%
RS.Open "SELECT ID,business,doctor,address,suite,city,state,zip " & _
" FROM abaw_drdata " & _
" WHERE state = '" & stateID & "' " & _
" ORDER BY city ", Conn1
WHILE NOT RS.EOF
docID=RS("ID")
business=RS("business")
doctor=RS("doctor")
address=RS("address")
suite=RS("suite")
city=RS("city")
state=RS("state")
zip=RS("zip")
%> |
|
|
<%=doctor%>
<%=business%> |
<%=address%><%IF suite<>"" THEN Response.Write "
" & suite%>
<%=city%>, <%=state%> <%=zip%> |
|
|
<%
RS.MoveNext
WEND
RS.Close
%>
|
|
|
