ASP Virker ikke...,
Okey hør her... jeg har det her script:<%
Response.Buffer = True
font = "<font size = '2' face='Arial'>"
strongfont = "<font size = '5' face='Arial'><Strong>"
linecolor = "#FF0000"
Set Rs = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("gbdb.mdb")
Rs.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
If Request.Servervariables("Content_Length") > 0 then
Sql = "Insert into t_gaestebog (Brugernavn, tilsalg, tilbage, Besked) values('" & Request("Brugernavn") & "','" & Request("tilsalg") & "','" & Request("tilbage") & "','" & Request("Besked") & "')"
Rs.Execute(Sql)
Response.Write strongfont & "Tak for det...</font></Strong><br><br>"
end if
If "" = Request.QueryString("Mode") then
Sql = "Select * from T_gaestebog order by dato DESC"
Set Record = Rs.Execute(Sql)
response.write "<html><head><title>Sælge/Købe</title></head><body bgcolor='#000000' text='#C0c0c0' link='#666666' alink='#666666' vlink='#666666'>"
response.write strongfont & "Sælge/Købe</font></strong>"
response.write "<table border='0' width='500'>"
Do While Not Record.EOF
response.write "<tr><td bgcolor='" & linecolor & "' colspan='2'></td></tr>"
response.write "<tr><td width='0' align='right'>" & font & "Brugernavn:</td>"
response.write "<td width='100%'>" & font & Record("Brugernavn") & "</td></tr>"
response.write "<tr><td width='0' align='right'>" & font & "Ting tilsalg:</td>"
response.write "<td width='100%'>" & font & Record("tilsalg") & "</td></tr>"
response.write "<tr><td width='0' align='right'>" & font & "Min. pris:</td>"
response.write "<td width='100%'>" & font & Record("tilbage") & "</td></tr>"
response.write "<tr><td width='0' align='right' valign='top'>" & font & "Besked:</td>"
response.write "<td width='100%'>" & font & Record("Besked") & "</td></tr>"
Record.MoveNext
Loop
response.write ""
Record.Close
RS.Close
end if
If "add" = Request.QueryString("Mode") then
response.write "<body bgcolor='#000000' text='#C0c0c0' link='#666666' alink='#666666' vlink='#666666'>"
response.write strongfont & "Købe/Sælge"
response.write "<form method='POST' action='" & Request.ServerVariables("SCRIPT_NAME") & "'>"
response.write "<div align='left'><table border='0' width='50%'>"
response.write "<tr><td valign='top' align='right' colspan='2' bgcolor='" & linecolor & "'></td></tr>"
response.write "<tr><td valign='top' align='right'>" & font & "Brugernavn:</td>"
response.write "<td valign='top'>" & font & "<input type='text' name='Brugernavn' size='40'></td></tr>"
response.write "<tr><td valign='top' align='right'>" & font & "Skriv her hvad du vil sælge:</td>"
response.write "<td valign='top'>" & font & "<input type='text' name='tilsalg' size='40'></td></tr>"
response.write "<tr><td valign='top' align='right'>" & font & "Skriv her hvad du mindst skal have:</td>"
response.write "<td valign='top'>" & font & "<input type='text' name='tilbage' size='40'></td></tr>"
response.write "<tr><td valign='top' align='right'>" & font & "Besked (behøves ikke):</td>"
response.write "<td valign='top'>" & font & "<textarea rows='5' name='Besked' cols='40'></textarea></td></tr>"
response.write "<tr><td colspan='2' valign='top' align='right'><div align='center'><center><p>" & font & "<input type='submit' value='Send' name='B1'> <input type='reset' value='Slet' name='B2'></center></div></td></tr>"
response.write "<tr align='center'><td colspan='2' valign='top' align='right' bgcolor='" & linecolor & "'></td></tr></table>"
response.write "</form>"
end if
%>
</body></html>
Når jeg kører den skriver den :
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/hh-logic/login/protect/handle/handle.asp, line 21
Hvad er der galt ??? Den virker fint hvis jeg kører ?mode=add
