Hi,



I wish to list a collection of field values as options in a drop-down 

selection list.



e.g.



In database class table under class field 

A

B

C



How do I get these to display as



<OPTION SELECTED="SELECTED">A</OPTION><OPTION>B</OPTION> etc..



Thanks in advance

Balaji 

<% 

If not objRS.EOF

    Response.Write("<select name=""select1"">" & vbcrlf)

    Do while not objRS.EOF

        Response.Write("<option>" & objRS("field1") & "</option>" & vbcrlf)

        objRS.movenext

    Loop

    Response.Write("</select>" & vbcrlf)

End If

%>



The first item will be selected by default.



Cheers

Ken





----- Original Message ----- 

From: "Balaji Krishnan" 

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, June 06, 2000 8:12 PM

Subject: [asp_databases] Return Field Entries on a Drop Down





> Hi,

> 

> I wish to list a collection of field values as options in a drop-down 

> selection list.

> 

> e.g.

> 

> In database class table under class field 

> A

> B

> C

> 

> How do I get these to display as

> 

> <OPTION SELECTED="SELECTED">A</OPTION><OPTION>B</OPTION> etc..

> 

> Thanks in advance

> Balaji