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

<vinodkus [at] gmail.com> wrote in message
news:1191833793.141917.251460 [at] 57g2000hsv.googlegroups.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")

PW wrote:

> <vinodkus [at] gmail.com> wrote in message
> news:1191833793.141917.251460 [at] 57g2000hsv.googlegroups.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