Populating dropdown menu using classic asp and mySQL

Hi all,

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:

<%
Dim objconn,objRS,strSQL

Set objconn = Server.CreateObject("ADODB.Connection")
objconn.Open strConnect

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>"
objRS.MoveNext
Loop
Response.Write "</select>"
objRs.Close
objconn.Close

%>

Select allOpen in new window