Det er også meget underligt. Nu kopierer jeg asp-koden ind her, og håber nogen kan hjælpe med mysteriet...
<%
iType = Request.QueryString("iType")
strSearchfor = Request.QueryString("strSearch")
If (iType = "" and strSearchfor = "") Then
response.Write "<option value="""">Please select genre</option>"
Else
set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("../legendarisk.mdb")
if IsEmpty(strSearchfor) Or strSearchfor = "" then
strSQL = "SELECT sTitel, sURL FROM lyrics WHERE iType IN (" & iType & ") ORDER BY sTitel "
else
strSQL = "SELECT sTitel, sURL FROM lyrics WHERE iType IN (" & iType & ") and sTitel Like '%" & strSearchfor & "%' ORDER BY sTitel "
end if
Set oRs = oConn.Execute(strSQL)
While not oRs.EOF
response.Write "<option value=""
http://www.legendenet.dk/legendarisk/lyrics/songs/" & oRs(1) & """>" & oRs("sTitel") & "</option>"
oRs.MoveNext
Wend
oRs.Close
Set oRs = Nothing
oConn.Close
End If
%>
Håber på svar....