I want to get the two coloumn data from user and display them in a combo box. I'm sending each colum data to differnt tables. Ofcourse it is related with inner joins.
I'm using SQL 7.0 on Win NT. Please tell me how to i Proceed.
to populate a recordset in a combo box:
in ASP page
<%
rs.open SQL,connection 'assuming both are there
%>
<select name="combo">
<%
do until rs.eof
%>
<option value="<%=rs(0)%>"><%=rs(0)%></option>
<%
rs.movenext
loop
%>
</select>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.