Visa lite kod, det är lättare att hitta felet då.
Trådstart#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
6 svar · 207 visningar · startad av jwradhe
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
Visa lite kod, det är lättare att hitta felet då.
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.