Avatar billede morpheus Nybegynder
22. juli 1999 - 23:42 Der er 11 kommentarer og
1 løsning

Datatyperne stemmer ikke overens i kriterieudtrykket....???!!!

HejSa !

Ja....så er han her igen ! :o)

Jeg får en fejl med nogle datatyper og kriterier....

Fejlen er her:
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e07'

[Microsoft][ODBC Microsoft Access 97-driver] Datatyperne stemmer ikke overens i kriterieudtrykket.

/kon/kon.asp, linje 44

Mit 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' height='267'>"
response.write "<tr>"
response.write "<td valign='top' height='290'>"
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='165'>"
response.write "<tr>"
response.write "<td width='50%' align='left' valign='top' height='148'>"
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='100%' noshade align='center'>"
response.write "<table width='98%' border='0' align='center' height='50'>"
response.write "<tr>"
response.write "<td width='15%' valign='top' height='13'>"
response.write "<div align='left'><b><font face='Verdana' size='2'>Navn:</font></b></div>"
response.write "</td>"
response.write "<td width='85%' valign='top' height='13'>"
response.write "<div align='left'>" & Record("Navn") & "</div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='15%' height='6' 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='85%' height='6' valign='top'>"
response.write "<div align='left'>" & Record("Ide") & "</div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='15%' height='14' valign='top'>"
response.write "<div align='left'><font face='Verdana' size='2'><b>Dato:</b></font></div>"
response.write "</td>"
response.write "<td width='85%' height='14' valign='top'>"
response.write "<div align='left'>" & Record("Dato") & "</div>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
response.write "</div>"
Record.MoveNext
loop
response.write "</table>"
Record.Close
Conn.Close

response.write "<p></p>"
response.write "</div>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
response.write "<div align='center'>"
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 "</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' height='797'>"
response.write "<p align='right'><img src='FDFfar.gif' width='91' height='30'></p>"
response.write "<div align='center'>"
response.write "<font face='Verdana' size='6'>Konkurrence</font></div>"
response.write "<table border='0' width='80%' align='center'>"
response.write "<tr>"
response.write "<td width='50%' align='left' valign='top' height='648'>"
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 den "
response.write "4. September kl. 13.00, for at deltage i konkurrencen om drinks m. m."
response.write "<br><br>"
response.write "Vinderne udråbes d. 4. September kl. 20.00<br><br>"
response.write "<font size='2'>(forslag om salg af alkohol m.v. godtages ikke, som et bidrag til konkurrencen)<br>"
response.write "<font size='3'><br>Allerede indsendte forslag: <a href='kon.asp'>klik her</a></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'>"
response.write "<input type='text' name='navn'></div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top' height='14'>"
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' height='14'>"
response.write "<div align='left'>"
response.write "<input type='text' name='adresse'>"
response.write "</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' size='8'></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'>By:</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'><input type='text' name='by' value='Svendborg'></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'>Telefon nr.:</font></b></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='left'><input type='text' name='tlf_nr' value='62' size='12'></div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'><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'>"
response.write "<input type='text' name='email'>"
response.write "</div>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='29%' height='69' 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='69' valign='top'>"
response.write "<textarea name='ide' cols='40' rows='6'></textarea>"
response.write "</td>"
response.write "</tr>"
response.write "<tr>"
response.write "<td width='29%' valign='top'>"
response.write "<div align='left'></div>"
response.write "</td>"
response.write "<td width='71%' valign='top'>"
response.write "<div align='center'>"
response.write "<input type='submit' name='submit' value='Send id&eacute;'>"
response.write "<input type='reset' name='reset' value='Slet alt'>"
response.write "</div>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
response.write "<div align='center'>"
response.write "<b><font face='Verdana' size='2'>Alle felter skal udfyldes !</font></b>"
response.write "<font face='Verdana' size='2'>"
response.write "<br>"
response.write "Hvis du er usikker p&aring; at give os dine personlige<br>"
response.write "oplysninger, s&aring; l&aelig;s mere <a href='sikkerhed.html'>her</a>.</font></div>"
response.write "</td>"
response.write "</tr>"
response.write "</table>"
response.write "<div align='center'>"
response.write "<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 "</table>"
response.write "</body>"
response.write "</html>"
end if
%>

Hjælp ?

<//morpheus\\>
Avatar billede villadsen Nybegynder
22. juli 1999 - 23:59 #1
Prøv at udskite linie 36 med:
sqlstmt = sqlstmt & "values ('" & navn & "'"
Avatar billede morpheus Nybegynder
23. juli 1999 - 00:44 #2
Villadsen>>>

Det hjalp ikke...har stadig fejlen i linie 44....

<//morpheus\\>
Avatar billede villadsen Nybegynder
23. juli 1999 - 01:08 #3
Ok nu tror jeg den er der:
Du laver en variabel i lin. 32 der ikke hedder det samme som når du kalder den i lin. 41:

Linie 32:
telefon_nr = strip(request("telefon_nr"))

Linie 41:
sqlstmt = sqlstmt & ",'" & tlf_nr & "'"

I øvrigt ville jeg personligt foretrække at skrive sql'en på 1 linie, da man så slipper for en del gnyffer:

sqlstmt = "INSERT INTO forslag (navn, dato, adresse, post_nr, city, tlf_nr, email, ide) VALUES ('"&navn&"', '"&dato&"', '"&adresse&"', '"&post_nr&"', '"&city&"', '"&telefon_nr&"', '"&email&"', '"&ide&"')"

Her har jeg kaldt variablen for telefon_nr.
Avatar billede sone Nybegynder
23. juli 1999 - 09:16 #4
Jeg mener at svaret er:

Du må ikke have et felt som hedder dato, da dato er navnet på en type i Access.

Peter
Avatar billede morpheus Nybegynder
23. juli 1999 - 13:27 #5
Villadsen>>

Hvilket af min source skal erstattes med:
sqlstmt = "INSERT INTO forslag (navn, dato, adresse, post_nr, city, tlf_nr, email, ide) VALUES ('"&navn&"', '"&dato&"', '"&adresse&"', '"&post_nr&"', '"&city&"', '"&telefon_nr&"', '"&email&"', '"&ide&"')"

???????????????????????????????????????
<//morpheus\\>
Avatar billede morpheus Nybegynder
23. juli 1999 - 13:28 #6
Sone......Jeg _HAR_ krydstjekket DB'en med scriptet....

Men ellers, det kunne sikkert have været en mulighed ! :O)

<//morpheus\\>
Avatar billede villadsen Nybegynder
23. juli 1999 - 15:14 #7
Det erstatter linie 40 til 48.

Evt. kan du lave det om til:

sqlstmt = "INSERT INTO forslag (navn, [dato], adresse, post_nr, city, tlf_nr, email, ide) VALUES ('"&navn&"', '"&dato&"', '"&adresse&"', '"&post_nr&"', '"&city&"', '"&telefon_nr&"', '"&email&"', '"&ide&"')"

for at undgå konflikt med dato'en.
Avatar billede ulrik Nybegynder
25. juli 1999 - 19:08 #8
sone >> Prøv at tænk dig om ASP er engelsk, er der et engelsk ord der hedder dato, næppe, men du har ret i det du siger eks. date, by osv. må ikke bruges!!!
Avatar billede sone Nybegynder
26. juli 1999 - 07:26 #9
ulrik >> Jeg har oplevet problemet på en dansk Access, men ellers ja!
Avatar billede villadsen Nybegynder
13. august 1999 - 09:31 #10
Goddag, morpheus, kan du bruge svaret?
Avatar billede morpheus Nybegynder
15. august 1999 - 16:49 #11
Ja da !

Her dine PointZ ! :o)

<//morpheus\\>
Avatar billede villadsen Nybegynder
15. august 1999 - 19:49 #12
Tak :-)
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