perhoyer....det er et Plug-In som skal installeret på serveren.
Morpheus....
Du bruger BY, alsår forståes som hvor en person bor i danmark. Prøv at oversætte det til engelsk. f.eks. "By the way". Alsår. du kan ikke bruge BY som en klonne i din tabel. Brug istedet CITY.
Okay. Du havde heller ikke Replace på din indsætninger. dvs. hvis en bruger brugte tegn som || eller ' ville der komme fejl.
Så.....jeg har simpltehen lavet helt lortet for dig. Du skulle kunne tage det som stå her under og sætte DIREKTE ind i dit nuværende script.
God fornøjelse.
.................
<%
' -----------------------------------------------------------------------
' Simpel gæstebog
' Udviklet af : Thomas Skall / NET//ACTIVE /
www.design4you.dk ' Dato : 11-01-1999
' Kommentar : Gør som du vil :-)
' -----------------------------------------------------------------------
Response.Buffer = True
linecolor = "#000000"
Set Rs = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("forslag.mdb")
Rs.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
If Request.Servervariables("Content_Length") > 0 then
'**** Vi begynder at sætte vores data ind
navn = request("navn")
navn = replace(navn,"'","''")
navn = replace(navn,"||","|")
navn = replace(navn,"<","<")
navn = replace(navn,">",">")
adresse = request("adresse")
adresse = replace(adresse,"'","''")
adresse = replace(adresse,"||","|")
adresse = replace(adresse,"<","<")
adresse = replace(adresse,">",">")
city = request("city")
city = replace(city,"'","''")
city = replace(city,"||","|")
city = replace(city,"<","<")
city = replace(city,">",">")
ide = request("ide")
ide = replace(ide,"'","''")
ide = replace(ide,"||","|")
ide = replace(ide,"<","<")
ide = replace(ide,">",">")
post_nr = request("post_nr")
post_nr = replace(post_nr,"'","''")
post_nr = replace(post_nr,"||","|")
post_nr = replace(post_nr,"<","<")
post_nr = replace(post_nr,">",">")
telefon_nr = request("telefon_nr")
telefon_nr = replace(telefon_nr,"'","''")
telefon_nr = replace(telefon_nr,"||","|")
telefon_nr = replace(telefon_nr,"<","<")
telefon_nr = replace(telefon_nr,">",">")
email = request("email")
email = replace(email,"'","''")
email = replace(email,"||","|")
email = replace(email,"<","<")
email = replace(email,">",">")
sqlstmt = "INSERT INTO forslag (navn, dato, adresse, post_nr, city, telefon_nr, email, ide)"
sqlstmt = sqlstmt & "values ('" & navn & "'"'"
sqlstmt = sqlstmt & ",'" & date & "'"
sqlstmt = sqlstmt & ",'" & adresse & "'"
sqlstmt = sqlstmt & ",'" & post_nr & "'"
sqlstmt = sqlstmt & ",'" & city & "'"
sqlstmt = sqlstmt & ",'" & telefon_nr & "'"
sqlstmt = sqlstmt & ",'" & email & "'"
sqlstmt = sqlstmt & ",'" & ide & "')"
Set RS = Conn.Execute(SQLStmt)
*** Her sender vi Webmasteren en email
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "Din.mail.server.dk"
JMail.Sendername = "Hjemmesiden"
JMail.Sender = "din@email.dk"
JMail.Subject = "Mail fra hjemmeside
JMail.body = "Der er kommet en mail i gæstebogen"
JMail.AddRecipient "webmasterens@email.dk"
JMail.Priority = 3
JMail.AddHeader "Originating-IP", Request.ServerVariables("REMOTE_ADDR")
JMail.Execute
response.write "<html>"
response.write "<head>"
response.write "<link REL='stylesheet' HREF='style.css' TYPE='text/css'>"
response.write "<title>BørneDiskotek - Konkurrence</title>"
response.write "</head>"
response.write "<body bgcolor='#FFFFFF'>"
response.write "<center><font face='Verdana' size='2'><b>Tak for din tilmelding til konkurrencen</b></font></center>"
end if
If "" = Request.QueryString("Mode") then
Sql = "Select * from forslag order by dato DESC"
Set Record = Rs.Execute(Sql)
response.write "<html>"
response.write "<head>"
response.write "<link REL='stylesheet' HREF='style.css' TYPE='text/css'>"
response.write "<title>BørneDiskotek - Konkurrence</title>"
response.write "</head>"
response.write "<body bgproperties='fixed' text='#000000' bgcolor='#FFFFFF'>"
response.write "<table width='75%' border='0' align='center' background='../../img/baggrund.gif'>"
response.write "<tr>"
response.write "<td valign='top'>"
response.write "<p align='right'><img src='../../img/FDFfar.gif' width='91' height='30'></p>"
response.write "<div align='center'><font face='Verdana' size='6'>Idéer til BørneDisko</font></div>"
response.write "<div align='center'>"
response.write "<table border='0' width='80%' align='center' height='235'>"
response.write "<tr>"
response.write "<td width='50%' align='left' valign='top' height='197'>"
response.write "<div align='left'>"
response.write "<p><font face='Verdana'>Her kan du se alle de forslag der er kommet til børnediskoteket !<br>"
response.write "Og måske selv få nogen gode idéer ?!</font></p>"
Do While Not Record.EOF
response.write "<hr width='80%' noshade align='center'>"
response.write "<table width='98%' border='0' align='center' height='103'>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>Navn:</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'>"
response.write "<font face='Verdana' size='2'>" & Record("Navn") & "</font>"
response.write "</div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='29%' height='52' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>Idé:</font></b></div>"
response.write "</td>"
response.write "<td width='71%' height='52' valign='top'>"
response.write "<div align='left'><font face='Verdana' size='2'>" & Record("Ide") & "</font>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
Record.MoveNext
loop
response.write "</table>"
Record.Close
RS.Close
response.write "</p>"
response.write "</font></div>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
response.write "<div align='center'>"
response.write "</div>"
response.write "</div>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
response.write "</div>"
response.write "<div align='center'><br>"
response.write "<font face='Verdana' size='2'>"
response.write "[<a href='disko.html'>Forsiden</a>] "
response.write "[<a href='konkurrence.html'>Konkurrence</a>] "
response.write "[<a href='udvalg.html'>Udvalget</a>] "
response.write "[<a href='ymca.html'>Y.M.C.A</a>]"
response.write "</font></div>"
response.write "</td>"
response.write "</tr>"
response.write "</body></html>"
end if
If "add" = Request.QueryString("Mode") then
response.write "<html>"
response.write "<head>"
response.write "<link REL='stylesheet' HREF='style.css' TYPE='text/css'>"
response.write "<title>BørneDiskotek - Konkurrence</title>"
response.write "</head>"
response.write "<body bgproperties='fixed' text='#000000' bgcolor='#FFFFFF'>"
response.write "<center>"
response.write "<font face='Verdana' size='3'><b>Skriv i gæstebogen</b></font>"
response.write "</center>"
response.write "<form method='POST' action='" & Request.ServerVariables("SCRIPT_NAME") & "'>"
response.write "<table width='75%' border='0' align='center' background='../../img/baggrund.gif'>"
response.write "<tr>"
response.write "<td valign='top'>"
response.write "<p align='right'><img src='../../img/FDFfar.gif' width='91' height='30'></p>"
response.write "<div align='center'><font face='Verdana' size='6'>Konkurrence</font> </div>"
response.write "<div align='center'>"
response.write "<table border='0' width='80%' align='center'>"
response.write "<tr>"
response.write "<td width='50%' align='left' valign='top'>"
response.write "<div align='left'>"
response.write "<p><font face='Verdana'>Konkurrencen går ud på at komme med et forslag til<br>"
response.write "hvordan vi kan gøre børnediskotekerne sjovere for dig.<br>"
response.write "Udfyld det nedenstående skema og tryk på send knappen, inden"
response.write "den 4. September Kl 13.00, for at deltage i konkurence om drinks m. m.<br>"
response.write "Vinderne udråbes d. 4. September kl. 20.00<br>"
response.write "<br>"
response.write "<font size='2'>"
response.write "(forslag om salg af alkohol m.v. godtages ikke, som et bidrag til konkurrencen)<br>"
response.write "<font size='3'><br>"
response.write "Allerede indsendte forslag: klik her</font></font></font></p>"
response.write "<hr noshade align='center'>"
response.write "<br>"
response.write "<table width='98%' border='0' align='center'>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>Navn:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'><input type='text' name='navn'></div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'><b><font face='Verdana size='2'>Adresse:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'>"
response.write "<input type='text' name='adresse'></div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>Post nr.:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'><input type='text' name='post_nr' value='5700'></div>"
response.write "</td></tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>By:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'>"
response.write "<input type='text' name='by' value='Svendborg'></div></td></tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>Telefonnr.:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'>"
response.write "<input type='text' name='telefon_nr' value='62'></div></td></tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>E-Mail:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'><input type='text' name='email'></div></td></tr>"
response.write "<tr>"
response.write "<td width='29%' height='52' valign='top'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>Idé:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' height='52' valign='top'>"
response.write "<div align='left'><textarea name='ide' rows='4' cols='35' '500' align='middle'></textarea></td></tr></table></font></div></td></tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'></div></td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'>"
response.write "<input type='submit' name='Submit' value='Send idé'>"
response.write "<input type='reset' name='Reset' value='Slet alt'>"
response.write "</div></td></tr></table>"
response.write "<div align='center'><br><b><font face='Verdana' size='2'>Felter markerat med * skal udfyldes !</font></b></div>"
response.write "</div></td></tr></table></div>"
response.write "<div align='center'><br><font face='Verdana' size='2'>"
response.write "[<a href='disko.html'>Forsiden</a>] "
response.write "[<a href='konkurrence.html'>Konkurrence</a>] "
response.write "[<a href='udvalg.html'>Udvalget</a>] "
response.write "[<a href='ymca.html'>Y.M.C.A</a>]"
response.write "</font></div></td></tr></table>"
response.write "</form></body></html>"
end if
%>
.................