ADODB.Field error '80020009

P

pennabianca24

Utente Attivo
21 Ago 2009
62
0
0
Buon giorno a tutti , mi chiamo Andrea ho un sito web di annunci gratuiti, ho un problema ,

Strumenti Webmaster Google mi da questo ERRORE :
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/scheda.asp, line 0
---------------------------------------------

Io non so come risolverlo mi potreste dare una mano GRAZIE



<!--#include file="conn.asp"-->
<!--#include file="connopencofigurazione.asp"-->


<%
'#############################################################################################
'####
'#### Script : Mercatino V.1.0
'####
'####
'####
'##############################################################################################

url = Request.QueryString("id")
cat = Request.QueryString("CatID")
catname = Request.QueryString("Cat")
categoria = Request.QueryString("categoria")
Subcat = Request.QueryString("Subcat")

If url = "" Then
Response.Redirect ("index.asp")
End If
If catname = "" Then
Response.Redirect ("index.asp")
End If

':::::::::::::::::::::::::::::::::::::::::: Contatore visite

strSql = "UPDATE annunci "
strSql = strSql & " SET annunci.hit = annunci.hit + 1 "
strSql = strSql & " WHERE (annunci.ID= " & Request.QueryString("ID") & ");"

conn.Execute (strSql)

sql=("select * from annunci where id=" & url)
set rs=conn.execute(sql)
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Scheda</title>
<style>
A:link, A:visited { text-decoration: none }
A:hover { text-decoration: underline }
</style>
<script>
function valid(){

var nome=document.theform.nome.value;
if (nome==""){
alert("Inserisci il tuo Nome!!")
document.theform.nome.focus()
return false
}
var cognome=document.theform.cognome.value;
if (cognome==""){
alert("Inserisci il tuo Cognome!!")
document.theform.cognome.focus()
return false
}
var messaggio=document.theform.messaggio.value;
if (messaggio==""){
alert("Inserisci il tuo messaggio!!")
document.theform.messaggio.focus()
return false
}
var oggetto=document.theform.oggetto.value;
if (oggetto==""){
alert("Inserisci il titolo del messaggio!!")
document.theform.oggetto.focus()
return false
}
var emailmit=document.theform.emailmit.value;
if (emailmit==""){
alert("Inserisci la tua Email!!")
document.theform.emailmit.focus()
return false
}
if (emailmit.indexOf('@', 0) == -1 || emailmit.indexOf('.', 0) == -1){ alert("Errore l'e-mail inserita non è valida!!");
document.theform.emailmit.focus()
return false
}
}

</script>
<script language="JavaScript">
<!-- hide on

function popup(popupfile,winwidth,winheight,scrollbars)
{
open(popupfile,"PopupWindow","resizable=yes,height=" + winheight + ",width=" + winwidth + ",scrollbars=" + scrollbars);
}

// hide off -->
</script>
</head>
<body topmargin="0">
<div align="center">
<center>
<table border="0" width="732" cellpadding="0" height="72" cellspacing="1">
<caption><!--#include file="top.asp"--></caption>
<tr>
<td width="159" valign="top" bgcolor="#3366FF" height="21" align="left">
<p align="center"><img border="0" src="immagini/Categorie.gif"></td>
<td width="9" rowspan="3" valign="top" height="70" align="left"><img border="0" src="immagini/null.gif" width="5" height="5"></td>
<td width="100%" valign="top" bgcolor="#3366FF" height="21"><font color="#FFFFFF" size="2" face="Arial"><b>&nbsp;Navigazione
:&nbsp;Categoria :</b></font><b><font color="#FFFFFF"><font size="2" face="Arial">
<%=categoria%> : <%=catname%>
</font></font> </b> </td>
</tr>
<tr>
<td width="159" valign="top" bgcolor="#EDEDED" height="403" align="left">
<table border="0" width="163" cellspacing="0" cellpadding="0">
<tr>
<td width="161" valign="top" bgcolor="#EDEDED"><!--#include file="Menusinistra.asp"-->
</td>
</tr>
<tr>
<td width="161" valign="top" bgcolor="#EDEDED">&nbsp;</td>
</tr>
<tr>
<td width="161" valign="top" bgcolor="#EDEDED"><img border="0" src="immagini/separatore.gif"></td>
</tr>
<tr>
<td width="161" valign="top" bgcolor="#EDEDED">&nbsp;</td>
</tr>
</table>
</td>
<td valign="top" height="403" width="100%">
<div align="center">
<center>
<table border="0" width="538" height="820" cellspacing="1" cellpadding="0">
<tr>
<td width="98" bgcolor="#FFFFFF" height="21" valign="top" align="center">
&nbsp;</td>
<td width="235" bgcolor="#FFFFFF" colspan="2" height="21" valign="top" align="center">
&nbsp;</td>
<td width="91" bgcolor="#FFFFFF" height="21" valign="top" align="center">
&nbsp;</td>
<td width="96" bgcolor="#FFFFFF" height="21" valign="middle" align="center">
&nbsp;</td>
</tr>
<!--BANNER IN ALTO -->


<!-- Fine BANNER IN ALTO -->
<tr>
<td width="98" bgcolor="#FFFFFF" height="31" valign="top" align="right">
<b><font size="5" face="Batang" color="#3366FF">Scheda</font></b></td>
<td width="235" bgcolor="#FFFFFF" colspan="2" height="31" valign="top" align="right">
<p align="left">&nbsp;</td>
<td width="91" bgcolor="#FFFFFF" height="31" valign="top" align="right">
&nbsp;</td>
<td width="96" bgcolor="#FFFFFF" height="31" valign="middle" align="right">
<p align="right">&nbsp;<font face="Arial" size="2">Visto ( <font color="#800000" face="Arial" size="2"><b><%=RS("hit")%> </b> </font>
)</font></td>
</tr>
<tr bgcolor="#D6EEFC">
<td width="532" bgcolor="#FFFFFF" height="21" valign="top" colspan="5">
<hr size="1" color="#98A0B8">
</td>
</tr>
<tr bgcolor="#D6EEFC">
<td bgcolor="#FFFFFF" height="26" width="98">
<p align="right"><font size="2" face="Arial">Numero ID <img border="0" src="immagini/bullet.gif"></font></td>
<td bgcolor="#FFFFFF" height="26" colspan="3" width="330"><font color="#800000"
face="Arial" size="2">&nbsp;<%=RS("iD")%> </font>
</td>
</center></center>
<td bgcolor="#FFFFFF" height="26" width="96">
<p align="right"><a href="javascript:popup('stampa.asp?id=<%=RS("ID")%>&amp;catID=<%=RS("iDCategoria")%>&amp;subcat=<%=RS("IDsottocat")%>&amp;categoria=<%=RS("Categoriatxt")%>&amp;cat=<%=RS("SotCategoriatxt")%>', 600, 530, 'yes')"><img border="0" src="immagini/print.gif" alt="Stampa annuncio"></a>
</td>
</tr>
<center>
<center>
<tr bgcolor="#D6EEFC">
<td bgcolor="#FFFFFF" height="20" width="98">
<p align="right"><font size="2" face="Arial">Oggetto <img border="0" src="immagini/bullet.gif"></font></td>
<td bgcolor="#FFFFFF" colspan="4" height="20" width="430"><font color="#800000"
face="Arial" size="2">&nbsp;<%=RS("Titolo")%> </font>
</td>
</tr>
<tr bgcolor="#D6EEFC">
<td bgcolor="#FFFFFF" height="20" width="98">
<p align="right"><font size="2" face="Arial">Inserito il <img border="0" src="immagini/bullet.gif">
</font></td>
<td bgcolor="#FFFFFF" height="20" width="157"><font color="#800000"
face="Arial" size="2">&nbsp;<%=RS("DataPost")%> </font>
</td>
<td bgcolor="#FFFFFF" height="20" width="74">
<p align="right"><font size="2" face="Arial">Expired il <img border="0" src="immagini/bullet.gif"></font></p>
</td>
<td bgcolor="#FFFFFF" height="20" colspan="2" width="191">
<p align="left"><font color="#800000" face="Arial" size="2"><b>&nbsp;<%=RS("DataDeletePost")%> </b> </font>
</p>
</td>
</tr>
<tr bgcolor="#D6EEFC">
<td width="532" bgcolor="#FFFFFF" colspan="5" height="21">
<hr size="1" color="#98A0B8" bgcolor="#FFFFFF">
</td>
</tr>
<tr>
<td width="98" bgcolor="#FFFFFF" align="right" height="20" valign="top">
<font size="2" face="Arial">&nbsp;Nome <img border="0" src="immagini/bullet.gif"> </font></td>
<td width="157" bgcolor="#FFFFFF" height="20" valign="top"><font color="#800000"
face="Arial" size="2">&nbsp;<%=RS("Nome")%> </font>
</td>
<td width="74" bgcolor="#FFFFFF" height="20" valign="top">
<p align="right"><font size="2" face="Arial">Citta' <img border="0" src="immagini/bullet.gif"></font>
</td>
<td bgcolor="#FFFFFF" height="20" colspan="2" valign="top" width="191"><font color="#800000"
face="Arial" size="2">&nbsp;<%if RS("citta") <> "" then %><%=RS("citta")%><% else %>----<%end if %></font>
</td>
</tr>
<tr>
<td width="98" bgcolor="#FFFFFF" align="right" height="21" valign="top">
<font size="2" face="Arial">Cognome <img border="0" src="immagini/bullet.gif"> </font>
</td>
<td width="157" bgcolor="#FFFFFF" height="21" valign="top"><font size="2" face="Arial"><b>&nbsp;<%if RS("cognome") <> "" then %></b></font><font color="#800000"
face="Arial" size="2"><%=RS("Cognome")%></font><font size="2" face="Arial"><b><% else %>----<%end if %></b></font>
</td>
<td width="74" bgcolor="#FFFFFF" height="21" valign="top">
<p align="right"><font size="2" face="Arial">Via</font> <font size="2" face="Arial"> <img border="0" src="immagini/bullet.gif"></font></p>
</td>
<td bgcolor="#FFFFFF" height="21" colspan="2" valign="top" width="191">
<font size="2" face="Arial" color="#800000">&nbsp;<%if RS("via") <> "" then %><%=RS("via")%><% else %>----<%end if %></font>
</td>
</tr>
<tr>
<td width="98" bgcolor="#FFFFFF" align="right" height="21" valign="top">
<font size="2" face="Arial">&nbsp;E-mail <img border="0" src="immagini/bullet.gif"></font>
</td>
<td width="157" bgcolor="#FFFFFF" height="21" valign="top">&nbsp;<font color="#800000"
face="Arial" size="2"><a href="mailto:<%=RS("email")%>"><img border="0" src="immagini/Mail.gif" alt="Casella postale"></a> </font>
</td>
<td width="74" bgcolor="#FFFFFF" height="21" valign="top">
<p align="right"><font size="2" face="Arial">Provincia <img border="0" src="immagini/bullet.gif"></font></td>
<td bgcolor="#FFFFFF" height="21" colspan="2" valign="top" width="191"><font color="#800000"
face="Arial" size="2">&nbsp;<%if RS("provincia") <> "" then %><%=RS("provincia")%><% else %>----<%end if %></font>
</td>
</tr>
<tr>
<td width="98" bgcolor="#FFFFFF" height="21" align="right" valign="top">
<p align="right"><font size="2" face="Arial">Tel... <img border="0" src="immagini/bullet.gif"></font></td>
<td width="157" bgcolor="#FFFFFF" height="21" valign="top">
<p align="left"><font color="#800000"
face="Arial" size="2">&nbsp;</font><font size="2" face="Arial"><b><%if RS("telefono") <> "" then %></b></font><font color="#800000"
face="Arial" size="2"><%=RS("telefono")%></font><font size="2" face="Arial"><b><% else %>----<%end if %></b></font>
</p>
</td>
<td width="74" bgcolor="#FFFFFF" height="21" valign="top">
<p align="right"><font size="2" face="Arial">Cap <img border="0" src="immagini/bullet.gif"></font>
</td>
<td bgcolor="#FFFFFF" height="21" colspan="2" valign="top" width="191">
<font color="#800000">
&nbsp;<font size="2" face="Arial"><%if RS("cap") <> "" then %><%=RS("cap")%><% else %>----<%end if %></font></font>
</td>
</tr>
<tr>
<td width="98" bgcolor="#FFFFFF" align="right" height="21" valign="top">
<font size="2" face="Arial">&nbsp;Prezzo <img border="0" src="immagini/bullet.gif"> </font>
</td>
<td width="157" bgcolor="#FFFFFF" height="21" valign="top"><font color="#800000" face="Arial" size="2">&nbsp;</font><font size="2" face="Arial"><b><%if RS("prezzo") <> "" then %></b><font color="#808000">Euro
</font></font><font color="#800000"
face="Arial" size="2"><%=RS("prezzo")%></font><font size="2" face="Arial"><b><% else %>----<%end if %></b></font>
</td>
<td bgcolor="#FFFFFF" height="21" width="74" valign="top">
<p align="right"><font size="2" face="Arial">Home <img border="0" src="immagini/bullet.gif"></font></p>
</td>
<td bgcolor="#FFFFFF" height="21" colspan="2" valign="top" width="191"><font size="2" face="Arial">&nbsp;<%if RS("home") <> "http://" then %><a href="<%=rs("home")%>" target="_blank"><img border="0" src="immagini/homepage.gif" alt="<%=rs("home")%>"></a><% else %>----<%end if %></font>
</td>
</tr>
</center></center>
<tr>
<td width="98" bgcolor="#FFFFFF" valign="top" height="32">
<p align="right">
<font face="Arial" size="2">Foto <img border="0" src="immagini/bullet.gif"></font>
</p>
</td>
<center>
<center>
<td bgcolor="#FFFFFF" valign="top" colspan="4" width="430" height="32">
<% if rs("file1") <> "" or rs("file2") <> "" or rs("file3") <> "" or rs("file4") <> "" then %>
<% if rs("file1") <> "" then %>&nbsp;<a href="javascript:popup('immagine.asp?id=<%=RS("ID")%>&amp;immagine=<%=RS("file1")%>', 600, 530, 'yes')"><img border="0" src="<%=PercorsoIM%><%=rs("file1")%>" width="40" height="40" alt="immagine"></a><%end if%>
<% if rs("file2") <> "" then %>&nbsp;<a href="javascript:popup('immagine.asp?id=<%=RS("ID")%>&amp;immagine=<%=RS("file2")%>', 600, 530, 'yes')"><img border="0" src="<%=PercorsoIM%><%=rs("file2")%>" width="40" height="40" alt="immagine"></a><%end if%>
<% if rs("file3") <> "" then %>&nbsp;<a href="javascript:popup('immagine.asp?id=<%=RS("ID")%>&amp;immagine=<%=RS("file3")%>', 600, 530, 'yes')"><img border="0" src="<%=PercorsoIM%><%=rs("file3")%>" width="40" height="40" alt="immagine"></a><%end if%>
<% if rs("file4") <> "" then %>&nbsp;<a href="javascript:popup('immagine.asp?id=<%=RS("ID")%>&amp;immagine=<%=RS("file4")%>', 600, 530, 'yes')"><img border="0" src="<%=PercorsoIM%><%=rs("file4")%>" width="40" height="40" alt="immagine"></a><%end if%>
<%
else
Response.Write "<font size='2' face='Arial'>Nessuna immagine disponibile</font>"
end if
%></td>
</tr>
</center></center>

<center>
<tr>
<td width="532" bgcolor="#FFFFFF" colspan="5" height="21">
<hr size="1" color="#98A0B8" bgcolor="#FFFFFF">
</td>
</tr>
</center>
<tr>
<td width="98" bgcolor="#FFFFFF" valign="top">
<p align="right">
<font size="2" face="Arial">Descrizione <img border="0" src="immagini/bullet.gif"></font>
</p>
</td>
<td width="430" bgcolor="#FFFFFF" colspan="4" valign="top">
<font face="Arial" size="2"><%=RS("Descrizione")%>
</font>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="top" width="532" colspan="5">
&nbsp;
</td>
<center>
</tr>
<tr>
<td width="532" bgcolor="#FFFFFF" valign="top" align="right" height="21" colspan="5">
<hr size="1" color="#98A0B8" bgcolor="#FFFFFF">
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="top" colspan="5" height="349" width="532">
<FORM name="theform" METHOD="POST" ACTION="contatto.asp?id=<%=Request.QueryString("id")%>&catID=<%=Request.QueryString("catID")%>&subcat=<%=Request.QueryString("subcat")%>&categoria=<%=Request.QueryString("categoria")%>&cat=<%=Request.QueryString("cat")%>" onsubmit="return valid (this)">
<table border="0" width="528" cellpadding="0" cellspacing="0">
<tr>
<td width="346" colspan="2"><font size="2" face="Arial">&nbsp;</font><b><font face="Arial" color="#98A0B8" size="3">Contatto
immediato</font></b></td>
</center>
<td width="182">
<p align="right"><font face="Arial" size="2">Contattato ( <font color="#800000" face="Arial" size="2"><b><%=RS("Contatti")%> </b> </font>
)</font></td>
</tr>
<tr>
<td width="119"><b><font face="Arial" color="#98A0B8" size="2">&nbsp;</font></b></td>
<td width="227"></td>
<td width="182"></td>
</tr>
<tr>

<td width="524" colspan="3"><b><font face="Arial" color="#FF0000" size="2">&nbsp;Tramite
questo Modulo potra' contattare immediatamente il destinatario</font></b></td>
</tr>
<tr>
<td width="524" colspan="3"><b><font face="Arial" color="#98A0B8" size="2">&nbsp;</font></b></td>
</tr>
<center>
<input type="hidden" name="webid" value="<%=RS("email")%>">
</center>
<tr>
<td width="117">
<p align="right"><font size="2" face="Arial">Nome <img border="0" src="immagini/bullet.gif">&nbsp;&nbsp;</font></td>
<td width="407" colspan="2"><input type="text" name="nome" size="27"></td>
</tr>
<tr>
<td width="117">
<p align="right"><font size="2" face="Arial">Cognome <img border="0" src="immagini/bullet.gif">&nbsp;&nbsp;</font></td>
<td width="407" colspan="2"><input type="text" name="cognome" size="27"></td>
</tr>
<tr>
<td width="117">
<p align="right"><font size="2" face="Arial">La </font><font size="2" face="Arial">sua
E-mail <img border="0" src="immagini/bullet.gif">&nbsp;&nbsp;</font>
</td>
<td width="407" colspan="2"><input type="text" name="emailmit" size="27"></td>
</tr>
<tr>
<td width="117">
<p align="right"><font size="2" face="Arial">Oggetto <img border="0" src="immagini/bullet.gif">&nbsp;&nbsp;</font>
</td>
<td width="407" colspan="2"><input type="text" name="oggetto" size="50" value="Annunci Gratuiti-Info -->> <%=RS("Titolo")%>" maxlength=43></td>
</tr>
<tr>
<td valign="top" width="117">
<p align="right"><font size="2" face="Arial">Richiesta <img border="0" src="immagini/bullet.gif">&nbsp;&nbsp;</font></td>
<center>
<td width="407" colspan="2"><textarea rows="5" name="messaggio" cols="43"></textarea></td>
</tr>
<tr>
<td valign="top" width="117">
</td>
<td width="407" colspan="2">&nbsp;</td>
</tr>
<tr>
<td valign="top" width="117">
</td>
<td width="407" colspan="2"><input type="submit" value="Invia" name="B1"> <input type="reset" value="Reinposta" name="B2"></td>
</tr>
</table>
</form>
</center>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="top" colspan="5" height="21" width="532">
&nbsp;
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="top" colspan="5" height="36" width="532">
<p align="center"><a href="upform.asp?catid=<%=cat%>&amp;subcat=<%=subcat%>&amp;categoria=<%=server.urlencode(categoria)%>&amp;cat=<%=server.urlencode(catname)%>"><img border="0" src="immagini/annuncio.gif"></a></p>
</td>
</tr>
<tr>
<td width="532" bgcolor="#FFFFFF" valign="top" align="right" height="21" colspan="5">
<p align="center">&nbsp;
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td width="159" valign="top" bgcolor="#3366FF" height="23" align="left"></td>
<td width="550" valign="top" bgcolor="#3366FF" height="23"></td>
</tr>
</table>
</div>
<p align="center"><!--#include file="Fine.asp"-->
</p>

</body>

</html>
<%
set strSql = nothing
rs.Close
set rs = nothing
rst.close
set rst = nothing
conn.Close
set conn = nothing
%>
 
Ciao,

usa il tasto # per inserire codce.

Non capisco la logica

url = Request.QueryString("id")


strSql = "UPDATE annunci "
strSql = strSql & " SET annunci.hit = annunci.hit + 1 "
strSql = strSql & " WHERE (annunci.ID= " & Request.QueryString("ID") & ");"

passi un ID contatore che hai chiamato url e nella sequel metti ID

il campo da aggiornare di + 1 si chiama annunci.hit e il contatore annunci.ID

il perché di due sequel

sql=("select * from annunci where id=" & url)
set rs=conn.execute(sql)

non hai una condizione di controllo sui dati corrispondenti

do while not rs.eof

e un
rs.movenext per spostare il puntatore al record successivo
loop per scorrere tutti i record.

Sistema, chiedi a un mod di inserire il codice tra tadg CODE e /CODE

Valelria.
 
Devi accedere o registrarti per poter rispondere.

Discussioni simili

K
[ASP] Errore: ADODB.Field error '800a0bcd'
Risposte
1
Visite
2K
Classic ASP
Paolo69
Paolo69
grottafelix
ADODB.Field (0x80020009)
Risposte
10
Visite
7K
Classic ASP
Vale2
Vale2
W
ADODB.Recordset error '800a0bb9'
Risposte
2
Visite
2K
Classic ASP
wuolfit_one
W
S
Problema con ADODB.Stream su MAC-Safari
Risposte
12
Visite
4K
Classic ASP
Sirio
S
A
adodb.recordset
Risposte
1
Visite
3K
Visual Basic
lukeonweb
lukeonweb
T
[ADOdb] Integrare più funzioni con una sola form
Risposte
1
Visite
2K
PHP
trunks73
T
M
ADODB.connection e ADODB.recordset: differenze e utilità.
Risposte
5
Visite
8K
Classic ASP
lukeonweb
lukeonweb
metalgemini
ADODB.Recordset error '800a0bb9'
Risposte
7
Visite
4K
Classic ASP
metalgemini
metalgemini
F
Steps campo input field
Risposte
1
Visite
1K
Javascript
Max 1
Max 1
L
tap gesture ios7 textfield
Risposte
0
Visite
1K
Sviluppo app per iOS
LukeFerrari
L
A
Attivare bottone solo dopo il riempimento di una JTextField
Risposte
2
Visite
2K
Java
ottofonsuppost
ottofonsuppost
D
Immagini dentro textfield che restano in linea (e non vadano a capo)
Risposte
0
Visite
1K
Flash
davide.samba
D
StarFish
[DELPHI] Filter di un campo TSQLTimeStampField
Risposte
0
Visite
1K
Programmazione
StarFish
StarFish
filippino
[Java] Inserimento Label e Text field
Risposte
1
Visite
2K
Java
Slyfer
S
J
Extreme Form Field Validator
Risposte
0
Visite
1K
Javascript
JavaScriptBank
J
A
inserimento valore dinamico in field al termine di url
Risposte
8
Visite
2K
PHP
Eliox
Eliox
T
gestire eventi in textfield
Risposte
1
Visite
2K
Programmazione
tonino1
T
frankiedeguello
CheckBox che attiva Textfield
Risposte
4
Visite
2K
Snippet Javascript
Vale_Barbato
V
M
action tramite textfield
Risposte
1
Visite
2K
Javascript
daviduccio
daviduccio
S
404 Error " Page not Find" Error
Risposte
0
Visite
804
SEO e Posizionamento
swetajoshi
S
Alto Basso