Populate a dropdown from database?

[elcaro2k]

Can someone tell me how to populate a dropdown from an Oracle table?

Thanks,
Ray

[raf]

Just like from any other db. Only the connectionstring and maybe the executed query need to be different.

But for building the optionlist for the dropdown, it's just like all other db's.


do while rsSoort.EOF=false 'rsSoort = your recordsetname
Response.Write("<option value=" & rsSoort.Fields("nummer")& ">") 'rsSoort.Fields("nummer") = the value for the option. Value for that record in tablevariable "nummer"
Response.Write(server.HTMLEncode(rsSoort.Fields("naam")) & "</option>")
rsSoort.MoveNext
loop


More threads on populating dropdowns:
http://www.codingforums.com/search.php?s=&action=showresults&searchid=140206&sortby=&sortorder=
(fastes results = run a search)

[elcaro2k]

Thanks!!!

[raf]

You're welcome.:thumbsup: