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]

<vi******@gmail.comwrote in message
news:11**********************@57g2000hsv.googlegro ups.com...

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]

PW wrote:

<vi******@gmail.comwrote in message
news:11**********************@57g2000hsv.googlegro ups.com...

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")

Many - many thanks sir