" kommer ikke med fra form
HejJeg har en kolonne i min Db hvor der er et " tegn, det kommer ikke med i min url, hvordan løser jeg det?
Kode:
<%
Response.Buffer = True
Response.Expires = 0
Set Con = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("daek.mdb")
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
sqlSize1 = ("SELECT DISTINCT size_1 FROM daek_tabel Order BY size_1 ASC ")
set rsSize1 = Con.execute(sqlSize1)
sqlSize2 = ("SELECT DISTINCT size_2 FROM daek_tabel Order BY size_2 ASC ")
set rsSize2 = Con.execute(sqlSize2)
sqlSize3 = ("SELECT DISTINCT size_3 FROM daek_tabel Order BY size_3 ASC ")
set rsSize3 = Con.execute(sqlSize3)
%>
<html>
<head>
<title>Dæk Database</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/test.css" type="text/css">
<link rel="stylesheet" href="/spalte.css" type="text/css">
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form method="get" type="select" action="visdaek.asp">
<p><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Vælg dæk bredde!
<br>
<select name="size1">
<option>
Alle
</option>
<%Do Until rsSize1.EOF%>
<option>
<%Response.Write rsSize1("size_1")%>
</option>
<% rsSize1.MoveNext
Loop%>
</select>
</font></p>
<font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Vælg dæk
højde!<br>
<select name="size2">
<option>
Alle
</option>
<%Do Until rsSize2.EOF%>
<option>
<%Response.Write rsSize2("size_2")%>
</option>
<% rsSize2.MoveNext
Loop%>
</select>
<br>
<br>
Vælg dæk størrlse!<br>
<select name="size3">
<option>
Alle
</option>
<%Do Until rsSize3.EOF%>
<option>
<% Response.Write rsSize3("size_3")%>
</option>
<% rsSize3.MoveNext
Loop%>
</select>
<br>
<br>
<input name="valg" type="submit" value="Vis dæk">
</font>
</form>
