Avatar billede morpheus Nybegynder
21. juli 1999 - 00:05 Der er 14 kommentarer og
1 løsning

Submit form til E-Mail og DB

Harj ASP-programmører !

Hvordan får jeg en form til at skrive både til en DB og bagefter sende det til en e-mail adresse ????

Har brugt noget kode til en Gæstebog...men mangler bare delen hvor den finder ud af at sende en e-mail til administratoren når formen er "submitted"....

HjÆlP ?

<//morpheus\\>
Avatar billede Dan Nim Seniormester
21. juli 1999 - 16:17 #1
..........
If Request.Servervariables("Content_Length") > 0 then
    Sql = "INSERT INTO forslag (navn, dato, adresse, post_nr, by, telefon_nr, email, ide) values('" & Request("navn") & "','" & Date() & "','" & Request("adresse") & "','" & Request("post_nr") & "','" & Request("by") & "','" & Request("telefon_nr") & "','" & Request("email") & "','" & Request("ide") & "')"
    Rs.Execute(Sql)   


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
.....


Jeg gad ikke skrive hele koden igen, men du kan sikkeret se det
Avatar billede chris Nybegynder
21. juli 1999 - 00:09 #2
Her er alt du skal bruge..!

http://www.4guysfromrolla.com/webtech/071599-1.shtml

Mvh
Chris
Avatar billede Dan Nim Seniormester
21. juli 1999 - 00:13 #3
argh, det er jo let :o)

Sæt dette ind lige efter at data'en er blevet sat ind i databasen/txt filen :

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
...

får jeg ikke point ?
Avatar billede morpheus Nybegynder
21. juli 1999 - 00:22 #4
Chatstuff>>>>> Øhhh....Det virker ikk'...eller jo det virker, men lidt for godt !
Den sender en mail hvergang der er en på siden...altså ligeså snart siden er aktiv...

<//morpheus\\>
Avatar billede Dan Nim Seniormester
21. juli 1999 - 00:56 #5
Så har du sat det forket ind!!!!!!!!!:

Du skal sætte det LIGE EFTER at gæstebogen opdatteret.

evt. så send dit script. så sætter jeg det ind for dig
Avatar billede morpheus Nybegynder
21. juli 1999 - 11:37 #6
Chatstuff>> Mit script ser således ud...

Øhh...Gider du lige kigge på SQL-sætningen..???

<%
' -----------------------------------------------------------------------
' 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
    Sql = "INSERT INTO forslag (navn, dato, adresse, post_nr, by, telefon_nr, email, ide) values('" & Request("navn") & "','" & Date() & "','" & Request("adresse") & "','" & Request("post_nr") & "','" & Request("by") & "','" & Request("telefon_nr") & "','" & Request("email") & "','" & Request("ide") & "')"
    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 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&oslash;rnediskoteket !<br>"
    response.write "Og m&aring;ske selv f&aring; nogen gode id&eacute;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&eacute;:</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>]&nbsp;"
    response.write "[<a href='konkurrence.html'>Konkurrence</a>]&nbsp;"
    response.write "[<a href='udvalg.html'>Udvalget</a>]&nbsp;"
    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'>Telefon                                            nr.:*</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&eacute;:*</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&eacute;'>"
    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>]&nbsp;"
    response.write "[<a href='konkurrence.html'>Konkurrence</a>]&nbsp;"
    response.write "[<a href='udvalg.html'>Udvalget</a>]&nbsp;"
    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
%>

<//morpheus\\>
Avatar billede Dan Nim Seniormester
22. juli 1999 - 00:31 #7
errr. først JEG GØR IKKE DETTE FOR POINT !!!!.

eee. det er rigtig.

Udskift denne linje i MIT script :

Set RS = Conn.Execute(SQLStmt)
med denne :
Rs.Execute(Sql


Det er lige over der hvor den sender en mail ud !
Avatar billede morpheus Nybegynder
21. juli 1999 - 16:59 #8
Beklager, Chris...:o(
Avatar billede morpheus Nybegynder
21. juli 1999 - 17:06 #9
Chatstuff>> Hvis du gider kan du så ikke lige lave et svar så du kan få dine point...???

Og så en anden ting....Hvad er der galt i SQL = INSERT...sætningen ????

FEJLEN:
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e14'

[Microsoft][ODBC Microsoft Access 97-driver] Der er en syntaksfejl i INSERT INTO-sætningen.

/d-net/users/fdf/docs/disko/konkurrence.asp, linje 18

<//morpheus\\>
Avatar billede perhoyer Nybegynder
21. juli 1999 - 19:37 #10
>>Chatstuff - denneher Jmail class ligger den standard på en NT eller er det en activeX der skal købes??
Avatar billede Dan Nim Seniormester
21. juli 1999 - 20:28 #11
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 &#124;&#124; 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,"&#124;&#124;","&#124;")
navn = replace(navn,"<","&lt;")
navn = replace(navn,">","&gt;")
adresse = request("adresse")
adresse = replace(adresse,"'","''")
adresse = replace(adresse,"&#124;&#124;","&#124;")
adresse = replace(adresse,"<","&lt;")
adresse = replace(adresse,">","&gt;")
city = request("city")
city = replace(city,"'","''")
city = replace(city,"&#124;&#124;","&#124;")
city = replace(city,"<","&lt;")
city = replace(city,">","&gt;")
ide = request("ide")
ide = replace(ide,"'","''")
ide = replace(ide,"&#124;&#124;","&#124;")
ide = replace(ide,"<","&lt;")
ide = replace(ide,">","&gt;")
post_nr = request("post_nr")
post_nr = replace(post_nr,"'","''")
post_nr = replace(post_nr,"&#124;&#124;","&#124;")
post_nr = replace(post_nr,"<","&lt;")
post_nr = replace(post_nr,">","&gt;")
telefon_nr = request("telefon_nr")
telefon_nr = replace(telefon_nr,"'","''")
telefon_nr = replace(telefon_nr,"&#124;&#124;","&#124;")
telefon_nr = replace(telefon_nr,"<","&lt;")
telefon_nr = replace(telefon_nr,">","&gt;")
email = request("email")
email = replace(email,"'","''")
email = replace(email,"&#124;&#124;","&#124;")
email = replace(email,"<","&lt;")
email = replace(email,">","&gt;")
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&oslash;rnediskoteket !<br>"
response.write "Og m&aring;ske selv f&aring; nogen gode id&eacute;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&eacute;:</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>]&nbsp;"
response.write "[<a href='konkurrence.html'>Konkurrence</a>]&nbsp;"
response.write "[<a href='udvalg.html'>Udvalget</a>]&nbsp;"
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&eacute;:*</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&eacute;'>"
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>]&nbsp;"
response.write "[<a href='konkurrence.html'>Konkurrence</a>]&nbsp;"
response.write "[<a href='udvalg.html'>Udvalget</a>]&nbsp;"
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
%>
.................
Avatar billede morpheus Nybegynder
21. juli 1999 - 22:49 #12
Chatstuff....Der er desværre nogle problemer med det script du har lavet ?!

Håber du selv ved hvor fejlen ligger...?
Efter jeg har submitted formen får jeg følgende fejl....

Der opstod en Microsoft VBScript-kørselsfejl fejl '800a01a8'

Et objekt er obligatorisk: 'Conn'

/d-net/users/fdf/docs/disko/kon.asp, linje 62
....

<//morpheus\\>
P.S
Vi kunne evt. snakke om 40 eXtra points ?!
Avatar billede ij Nybegynder
22. juli 1999 - 14:01 #13
Det er fordi du skal åbne databaseforbindelse med Conn, istedet for RS.

Nedenfor er koden rettet, du må selv finde det i din egen kode, men det ligger i topppen et sted.

Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("forslag.mdb")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
  If Request.Servervariables("Content_Length") > 0 then
Avatar billede Dan Nim Seniormester
22. juli 1999 - 15:46 #14
øøø. Fejl

eksperten bytter rundt på rækkefølgen :

  errr. først JEG GØR IKKE DETTE FOR POINT !!!!.

eee. det er rigtig.

Udskift denne linje i MIT script :

Set RS = Conn.Execute(SQLStmt)
med denne :
Rs.Execute(Sql


Det er lige over der hvor den sender en mail ud !
Avatar billede morpheus Nybegynder
22. juli 1999 - 16:05 #15
Chatstuff:
Vi prøver lige igen....:o)

Får stadig nogle fejl...
<script>
<%
' -----------------------------------------------------------------------
' Gæstebog, udviklet til en konkurrence-ting af Floffy & (~~morpheus~~)
' Udviklet af : Thomas Skall / NET//ACTIVE / www.design4you.dk
' Dato : 11-01-1999
' Kommentar : Gør som du vil :-)
' -----------------------------------------------------------------------

function strip(foo)
    foo = replace(foo,"""","''")
    foo = replace(foo,"|","&#124;")
    foo = replace(foo,"<","&lt;")
    foo = replace(foo,">","&gt;")
    strip = foo
end function

Response.Buffer = True

linecolor  = "#000000"

Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("forslag2.mdb")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
  If Request.Servervariables("Content_Length") > 0 then

'**** Vi begynder at sætte vores data ind
navn = strip(request("navn"))
adresse = strip(request("adresse"))
city = strip(request("city"))
ide = strip(request("ide"))
post_nr = strip(request("post_nr"))
telefon_nr = strip(request("telefon_nr"))
email = strip(request("email"))

sqlstmt = "INSERT INTO forslag (navn, dato, adresse, post_nr, city, tlf_nr, email, ide)"
sqlstmt = sqlstmt & "values ('" & navn & "'"'"
sqlstmt = sqlstmt & ",'" & dato & "'"
sqlstmt = sqlstmt & ",'" & adresse & "'"
sqlstmt = sqlstmt & ",'" & post_nr & "'"
sqlstmt = sqlstmt & ",'" &  city & "'"
sqlstmt = sqlstmt & ",'" & tlf_nr & "'"
sqlstmt = sqlstmt & ",'" & email & "'"
sqlstmt = sqlstmt & ",'" & ide & "')"
Conn.Execute(SQLstmt)

'*** Her sender vi Webmasteren en email
sBody = "Navn: " & Request("navn") & "<br>"
sBody = "Adresse: " & Request("adresse") & "<br>"
sBody = "Post nr.: " & Request("post_nr") & "<br>"
sBody = "By: " & Request("city") & "<br>"
sBody = "Telefon nr.: " & Request("tlf_nr") & "<br>"
sBody = "E-Mail: " & Request("email") & "<br>"
sBody = "Idé: " & Request("ide") & "<br>"
response.write "<br>"
sBody = "Dato for indsending: " & Request("Dato") &"<br>"

Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "mail.d-net.dk"
JMail.Sender = "webmaster@d-net.dk"
JMail.AddRecipient "webmaster@d-net.dk"
'JMail.AddRecipientExx "modtagermail","modtagernavn"
JMail.Body = sBody
JMail.Subject = "FDF BørneDisko Konkurrence"
JMail.Priority = 3
JMail.AddHeader "Originating-IP", Request.ServerVariables("REMOTE_ADDR")
JMail.Execute
Set JMail = Nothing


'***Her vises resultaterne***'
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 =  conn.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='baggrund.gif'>"

response.write "<tr>"
response.write "<td valign='top'>"
response.write "<p align='right'><img src='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&oslash;rnediskoteket !<br>"
response.write "Og m&aring;ske selv f&aring; nogen gode id&eacute;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&eacute;:</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
Conn.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>]&nbsp;"
response.write "[<a href='konkurrence.html'>Konkurrence</a>]&nbsp;"
response.write "[<a href='udvalg.html'>Udvalget</a>]&nbsp;"
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
 

'***Tilmelding***'
  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 "<form method='POST' action='" & Request.ServerVariables("SCRIPT_NAME") & "'>"
response.write "<table width='75%' border='0' align='center' background='baggrund.gif'>"
response.write "<tr>"
response.write "<td valign='top'>"
response.write "<p align='right'><img src='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'>Telefon Nr.:*</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'>"
response.write "<input type='text' name='tlf_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&eacute;:*</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&eacute;'>"
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>]&nbsp;"
response.write "[<a href='konkurrence.html'>Konkurrence</a>]&nbsp;"
response.write "[<a href='udvalg.html'>Udvalget</a>]&nbsp;"
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
%>
</script>


Fejl:
Der opstod en Microsoft VBScript-kørselsfejl fejl '800a01a8'

Et objekt er obligatorisk: 'RS'

/kon/kon.asp, linje 44

<//morpheus\\>

P.S
Håber stadig du vil hjælpe nu du har fået dine pointz...:o)
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester