Being fairly new to coding in general. I have a page with dropdown menus available. I would like one of these to be customer controlled and updateable. I know how to insert and update values in a mySQL database. However populating a dropdown menu using data from that database is an issue. I have 3 records in my database (Table name: Lokation - Column name: Lokation_navn). The below code clearly appears to be displaying these 3 records (it is 3 records long when I view it on the web page). However there is no text visible???? Any help and/or direction much appreciated!
Here is my code - strConnect represents the database credentials and comes from an include file at the top of the page:
Set objconn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT distinct(Lokation_navn) FROM Lokation ORDER BY Lokation_navn Desc"
objRS.Open strSQL, objconn
Response.Write "<select name=lokation><option value='''' selected>Vælg lokation</option>"
Do While Not objRS.EOF
Response.Write "<option value=''" & objrs("Lokation_navn") &"''>"& objRs("Lokation_navn") &"</option>"