Visa lite kod, det är lättare att hitta felet då. :)
Frågan#1
va ska jag göra om de står???
ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
/las_trad.asp, line 233
och rad 233 är
RecSet.AddNew
Felmeddelande
6 svar · 202 visningar · startad av jwradhe
ee de fixade sig.
får meddelandet
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum_default.asp, line 54
av denna kod
<%
Session.LCID = 1053
%>
<%
Set Connect = Server.CreateObject("ADODB.connection")
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../db/forum.mdb")
Set RecSet = Server.CreateObject("ADODB.Recordset")
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script src="forum.js"></script>
<style type="text/css">
<!--
a:link { text-decoration: none ; color: #666666; }
a:visited { text-decoration: none; color: #666666; }
a:active { text-decoration: none; color: #666666; }
a:hover { text-decoration: none; color: #333333; }
-->
</style>
</head>
<body bgcolor="#FFFFFF" text="#333333">
<div align="center">
<table style="border-top: #333333 1px solid;border-bottom: #333333 1px solid;border-left: #333333 1px solid;border-right: #333333 1px solid; " width="650" border="0" cellspacing="0" cellpadding="0" bgcolor="#CCCCCC">
<tr>
<td style="border-bottom: #333333 1px solid " height="34">
<table width="650" border="0" cellspacing="10" cellpadding="0">
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="6"><b>Forum
v 1</b></font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="11" valign="top">
<table style="border-bottom: #333333 1px solid " width="650" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="24"> </td>
<td width="208"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Rubrik</font></td>
<td width="228"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Postat
av</font></td>
<td width="10"> </td>
<td width="52"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Svar</font></td>
<td width="128"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
Senast svar</font></td>
</tr>
</table>
<%
SQL = "SELECT * from forum WHERE svarsid=1 order by senast desc "
[B]RecSet.Open SQL, Connect, 3, 3 <------- rad 54[/B]
Do While not RecSet.EOF %>
<table style="border-bottom: #333333 1px solid " width="650" border="0" cellspacing="0" cellpadding="0" height="30">
<tr valign="middle">
<td width="25"> </td>
<td width="209"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><a href=las_trad.asp?id=<%=RecSet("id")%>><%=RecSet("rubrik")%></a></font></td>
<td width="227"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><%=RecSet("namn")%></font></td>
<td width="10"> </td>
<td width="54"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"><%=RecSet("last")%></font></td>
<td width="124"> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<%If RecSet("Svar") > 0 Then%>
<%=RecSet("Senast")%>
<%Else%>
<%=RecSet("datum")%>
<%End If%>
</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="31">
<table width="650" border="0" cellspacing="10" cellpadding="0">
<tr>
<% RecSet.MoveNext %>
<% Loop %>
<%
'----------------------- Form start -----------
%>
<form method="post" action="add_trad.asp">
<td>
<table width="630" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="47"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
Namn :</font></td>
<td width="140"> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input type="text" name="namn">
</font></td>
<td width="58"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
Hemsida:</font></td>
<td width="263"> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input type="text" name="hemsida">
</font></td>
<td width="122">
<input type="hidden" name="id" value="1">
<font face="Verdana, Arial, Helvetica, sans-serif" size="1"></font></td>
</tr>
<tr>
<td width="47"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Epost
:</font></td>
<td width="140"> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input type="text" name="epost">
</font></td>
<td width="58"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">Rubrik:</font></td>
<td width="263"> <font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<input type="text" name="rubrik">
</font></td>
<td width="122"><font face="Verdana, Arial, Helvetica, sans-serif" size="1"></font></td>
</tr>
</table>
<table width="630" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="47"> </td>
<td width="584"><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
<textarea name="inlagg" cols="45" rows="10"></textarea>
</font></td>
</tr>
<tr>
<td width="47"> </td>
<td width="584">
<input type="submit" name="Submit" value="Posta">
<input type="reset" name="Submit2" value="Gör om">
</td>
</tr>
</table>
</td>
</form>
<%
'----------------- form slut ----------------
%>
<%
RecSet.Close
Connect.Close
%>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>
vad e fel?? jag hittar inget...
de funkade nu...fixade de å annat sätt.. kan nån admin plocka bort tråd kanske?
Berätta istället hur du löste dina problem, så kan personer med samma problem lösa dem. :)
Red. zzzzzzzzzz.... va inget.