how to show more than column value in combo box

[vinodkus]

dear sir/madam
I have a problem . I have a table of field name ,roll_name, age
I have to show name and roll_number in combo box list. please help me
i m using it
<select name=id1>
<option value="<rs(0)>"><%=rs(0)%><%=rs(1)%></option>
please correct this syntex

 

[PW]

dear sir/madam
I have a problem . I have a table of field name ,roll_name, age
I have to show name and roll_number in combo box list. please help me
i m using it
<select name=id1>
<option value="<rs(0)>"><%=rs(0)%><%=rs(1)%></option>
please correct this syntex

I always do something like this when I want to display more than 1 column of
data ...

myOption = rs1("ESCI") & " | " & rs1("ESCN")

 

[vinodkus]

I always do something like this when I want to display more than 1 column of
data ...

myOption = rs1("ESCI") & " | " & rs1("ESCN")

Many - many thanks sir