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,"|","|")
foo = replace(foo,"<","<")
foo = replace(foo,">",">")
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ørnediskoteket !<br>"
response.write "Og måske selv få nogen gode idé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é:</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>] "
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 "</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é:</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é'>"
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å at give os dine personlige<br>"
response.write "oplysninger, så læ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>] "
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 "</table>"
response.write "</body>"
response.write "</html>"
end if
%>
Hjælp ?
<//morpheus\\>
