fejl help.
HejsaNogen der kan hjælpe med af finde fejlen.?
Jeg for en fejl i mit system, når jeg klikker Rediger.
Microsoft JET Database Engine error '80040e14'
Invalid use of '.', '!', or '()'. in query expression 'Kr. 25'.
/rediger.asp, line 6
Sådan her ser siden ud:
rediger.asp
<!-- #include file="base.asp" -->
<%
Session.LCID = 1030
if request("mode") = "rediger" THEN
SQL1 = "UPDATE arrangement set dato = '" & request("dato") & "', extra = '" & request("extra") & "', klokken = '" & request("klokken") & "', prisv = " & request("prisv") & ", prisb = " & request("prisb") & ", pladser = '" & request("pladser") & "', kategori=" & request("kategori") & " WHERE id = " & request("id")
Conn.execute(SQL1)
Response.write "<strong>Begivenhed redigeret</strong><br><br><br>"
End if
If request("mode") = "slet" THEN
conn.execute("DELETE FROM arrangement WHERE id = " & request("id"))
Response.redirect "kal.asp"
END If
sqlind = "SELECT * FROM arrangement WHERE id = " & request("id")
set rsind = conn.execute(sqlind)
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style/akstyle.css" rel="stylesheet" type="text/css">
<title>Redigering</title>
</head>
<body>
<span class="alm_text_sort">Redigering af Fisketure Kalender</span><br>
<br>
<form name="form1" method="post" action="rediger.asp">
<input name="mode" type="hidden" value="rediger">
<input name="id" type="hidden" id="mode" value="<%= rsind("id") %>">
<table width="200" border="0">
<tr>
<td width="129" class="alm_text_sort">Dato:</td>
<%
date1 = "01-01-" & year(date)
date2 = "31-12-" & year(date)+5
val=DateDiff("d",date1,date2)
%>
<td width="61"><select name="dato" id="dato">
<option value="<%= rsind("dato") %>" selected><%= rsind("dato") %></option>
<% For i = 0 to val %>
<option value="<%= dateadd("d", i, date1) %>"><%= dateadd("d", i, date1) %></option>
<%next %>
</select></td>
</tr>
<tr>
<td class="alm_text_sort">Extra:</td>
<td><textarea name="extra" id="extra"><%= rsind("extra") %></textarea></td>
</tr>
<tr>
<td class="alm_text_sort">Klokken:</td>
<td><input name="klokken" type="text" id="klokken" value="<%= rsind("klokken") %>"></td>
</tr>
<tr>
<td class="alm_text_sort">Pris Voksen :</td>
<td><select name="prisv" id="select2">
<option value="Kr. 25">Kr. 25
<option value="Kr. 50">Kr. 50
<option value="Kr. 75">Kr. 75
<option value="Kr. 100">Kr. 100
<option value="Kr. 125">Kr. 125
<option value="Kr. 150">Kr. 150
<option value="Kr. 175">Kr. 175
<option value="Kr. 200">Kr. 200
<option value="Kr. 225">Kr. 225
<option value="Kr. 250">Kr. 250
<option value="Kr. 275">Kr. 275
<option value="Kr. 300">Kr. 300
<option value="Optaget">Optaget
</select></td>
</tr>
<tr>
<td class="alm_text_sort">Pris Barn: </td>
<td><select name="prisb" id="select">
<option value="Kr. 25">Kr. 25
<option value="Kr. 50">Kr. 50
<option value="Kr. 75">Kr. 75
<option value="Kr. 100">Kr. 100
<option value="Kr. 125">Kr. 125
<option value="Kr. 150">Kr. 150
<option value="Kr. 175">Kr. 175
<option value="Kr. 200">Kr. 200
<option value="Kr. 225">Kr. 225
<option value="Kr. 250">Kr. 250
<option value="Kr. 275">Kr. 275
<option value="Kr. 300">Kr. 300
<option value="Optaget">Optaget
</select></td>
</tr>
<tr>
<td class="alm_text_sort">Antal ledige pladser: </td>
<td><select name="pladser" id="pladser">
<option value="Optaget">Optaget
<option value="Få Ledige pladser">Få Ledige pladser
<option>Ledige Pladser
<option value="Blå Flag">Blå Flag
<option value="Hele Skibet Kr. 1.000,-">Hele Skibet Kr. 1.000,-
<option value="Hele Skibet Kr. 1.500,-">Hele Skibet Kr. 1.500,-
<option value="Hele Skibet Kr. 2.000,-">Hele Skibet Kr. 2.000,-
<option value="Hele Skibet Kr. 2.500,-">Hele Skibet Kr. 2.500,-
<option value="Hele Skibet Kr. 3.000,-">Hele Skibet Kr. 3.000,-
<option value="Hele Skibet Kr. 3.500,-">Hele Skibet Kr. 3.500,-
<option value="Hele Skibet Kr. 4.000,-">Hele Skibet Kr. 4.000,-
<option value="Hele Skibet Kr. 4.500,-">Hele Skibet Kr. 4.500,-
<option value="Hele Skibet Kr. 5.000,-">Hele Skibet Kr. 5.000,-
</select></td>
</tr>
<tr>
<td class="alm_text_sort">Havn:</td>
<td><select name="kategori" id="kategori">
<% sql = "SELECT * FROM kategori"
set rs = conn.execute(sql)
if not (rs.bof or rs.eof) then
While Not rs.EOF
if rs("id") = rsind("kategori") then %>
<option value="<%= rs("id") %>" selected><%= rs("kategori") %></option>
<% else %>
<option value="<%= rs("id") %>"><%= rs("kategori") %></option>
<% end if %>
<%
rs.movenext %>
<% wend
end if %>
</select></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="Submit" value="Rediger "></td>
</tr>
</table>
<p> </p>
</form>
<form name="form2" method="post" action="">
<p>
<input name="mode" type="hidden" id="mode" value="slet">
<input name="id" type="hidden" id="mode" value="<%= rsind("id") %>">
<br>
<br>
<input type="submit" name="Submit" value="Slet">
</p>
</form>
<span class="alm_text_sort">
</p>
<a href="kal.asp">Tilbage...
</a></span>
</body>
</html>
