Populate list box with the values from the recordset

[sabavno]

Hi,

I have a recordset that returns three columns

params="Select LastName, FirstName, Initial from Names"
Set rs = db1.Execute(get_params)

Is it possible to populate the list box with the values from the recordset so that the list would contain the following entries:

Smith, John (JS)
Smith, Bob (BS)
Smith, Ted (TS)

Can I assign the recordset values to the array?

Any help would be greatly appreciated.

Thanks.

 

[bastienk]

sure

while not rs.eof

response.write "<option value="" & rs(0) & "," & rs(1) & "">" & rs(0) & "," & rs(1) & "(" & rs(2) & ")"

Bastien

Cat, the other other white meat