Fuck hvor jeg bare er træt af det her !!
Er der en rar person der vil hjælpe mig med at løse problemt ?Jeg får ALTID denne fejl ALTID...Jeg er snart træt af ASP !
Microsoft OLE DB Provider for ODBC Drivers error \'80040e07\'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/ringtones.asp, line 39
----------------------
Her er scripten:
<tr>
<td width=\"61%\" height=\"11\"><font face=\"tahoma\" size=\"2\"> </font></td>
<td width=\"39%\" height=\"11\"><font face=\"tahoma\" size=\"2\"> </font></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr><table border=\"0\" width=\"700\" bgcolor=\"#000000\" cellspacing=\"1\" cellpadding=\"3\" align=\"center\">
<tr>
<td bgcolor=\"#FFFFFF\" valign=\"top\" colspan=\"2\">
<div align=\"center\"> <a href=\"ringtones.asp?alfa=ABCD\">ABCD</a> - <a href=\"ringtones.asp?alfa=EFGH\">EFGH</a>
- <a href=\"ringtones.asp?alfa=IJKL\">IJKL</a> - <a href=\"ringtones.asp?alfa=MNOP\">MNOP</a>
- <a href=\"ringtones.asp?alfa=QRST\">QRST</a> - <a href=\"ringtones.asp?alfa=UVWX\">UVWX</a>
- <a href=\"ringtones.asp?alfa=ZY%C6%C5%D80123456789\">ZY 1-9</a> </div>
</td>
</tr>
<tr>
<td bgcolor=\"#FFFFFF\" valign=\"top\" colspan=\"2\">
<div align=\"center\">
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"test.mdb\")
str_sql2 = \"SELECT * FROM ringtones WHERE godkendt=\'Ja\'\"
If Request(\"alfa\") > \"\" Then str_sql2 = str_sql2 & \" AND instr(\'\" & LCase(Request(\"alfa\")) & \"\',lcase(left(ringtone,1)))>0\"
Set rs = Conn.Execute (str_sql2) --> linje 39 <--
%>
<div align=\"center\">
<%
if rs.EOF then
%>
<span class=\"overskrift\">Ingen Ringetoner ! </span>
<%
else
%>
<table width=\"97%\" height=\"24\" cellspacing=\"2\">
<tr bgcolor=\"#0099FF\">
<td width=\"33%\"><font face=tahoma size=2 color=\"#FFFFFF\"><b>ToneNavn</b></font></td>
<td width=\"18%\"><font face=tahoma size=2 color=\"#FFFFFF\"><b>Nokia</b></font></td>
<td width=\"16%\"><font face=tahoma size=2 color=\"#FFFFFF\"><b>Ericsson</b></font></td>
<td width=\"27%\"><font face=tahoma size=2 color=\"#FFFFFF\"><b>Siemens</b></font></td>
<td width=\"6%\"><font face=tahoma size=2 color=\"#FFFFFF\"><b>Hits:</b></font></td>
</tr>
<%
Do Until rs.EOF
%>
<tr>
<td width=\"33%\"><font face=tahoma size=2> <% = rs(\"ringtone\") %></font></td>
<td width=\"18%\">nokia</td>
<td width=\"16%\">ericsson</td>
<td width=\"27%\">siemens</td>
<td width=\"6%\"></td>
</tr>
<%
rs.MoveNext
Loop
%>
<p></p>
</table>
</div>
<% end if %>
<p><br>
<br>
<br>
<br>
<font size=\"1\"> </font> </p>
</div>
</td>
</tr>
</table>
