Erro "ADODB.Recordset error '800a0bb9' "

Gabriel Felipe · Maio 27, 2007

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/noticia.asp, line 12

Esse é o erro que está me tirando o sono se algum puder me ajudar!!

11 var RsExibirNot = Server.CreateObject("ADODB.Recordset");
12 RsExibirNot.ActiveConnection = MM_cadastro_STRING;
13 RsExibirNot.Source = "SELECT * FROM noticia WHERE cod = '"+ RsExibirNot__MMColParam.replace(/'/g, "''") + "' ORDER BY cod DESC";
14 RsExibirNot.CursorType = 0;
15 RsExibirNot.CursorLocation = 2;
16 RsExibirNot.LockType = 1;
17 RsExibirNot.Open();

vagner.net · Maio 27, 2007

Essa MM_cadastro_STRING, é seu objeto de conexão ou é uma STRING de conexão!?

Gabriel Felipe · Maio 27, 2007

Consegui acertar eu Mudei a pagina de javascript pra Vbscript e deu certo só tem um problema agora se puderem me ajudar.Microsoft VBScript compilation error '800a03f6' Expected 'End' /noticia.asp, line 312 ***********Ele diz que está esperando esse End porém já tentei colocar de naum vai a linha tá assimRsExibirNot.Close() O que devo fazer depois!!

vagner.net · Maio 27, 2007

Provavelmente algum comando não foi fechado, porém, se você postar o código fica + fácil ajudar!

Gabriel Felipe · Maio 27, 2007

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%

Dim RsExibirNot__MMColParam

RSExibirNot = "1"

if (Request.QueryString("cod"))<> "undefined" Then

RsExibirNot__MMColParam = Request.QueryString("cod")

}

%>

<%

Dim RsExibirNot

Dim RsExibirNot_numRows

Set RsExibirNot = Server.CreateObject("ADODB.Recordset")

RsExibirNot.ActiveConnection = MM_Cadastro_STRING

RsExibirNot.Source = "SELECT * FROM noticia WHERE cod = '+ RsExibirNot__MMColParam.replace' ORDER BY cod DESC"

RsExibirNot.CursorType = 0

RsExibirNot.CursorLocation = 2

RsExibirNot.LockType = 1

RsExibirNot.Open()

RsExibirNot_numRows = 0

%>

<html>

<head>

<title>Câmara Municipal de Várzea Paulista</title>

<!--

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

//-->

</script>

<meta http-equiv="Content-Type" content="text/html;">

<script language="JavaScript">

<!--

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

//-->

</script>

<meta http-equiv="Content-Type" content="text/html;">

<script language="JavaScript">

<!--

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

function mmLoadMenus() {

if (window.mm_menu_0524203345_0) return;

window.mm_menu_0524203345_0 = new Menu("root",138,26,"Arial, Helvetica, sans-serif",13,"#000000","#f3f3f3","#d3d3d3","#999999","left","middle",3,0,1000,-5,7,true,false,true,0,false,false);

mm_menu_0524203345_0.addMenuItem("Historico","window.open('\historico.htm', '_self');");

mm_menu_0524203345_0.addMenuItem("Funcionamento","window.open('\funciona.htm', '_self');");

mm_menu_0524203345_0.hideOnMouseOut=true;

mm_menu_0524203345_0.menuBorder=0;

mm_menu_0524203345_0.menuLiteBgColor='#ffffff';

mm_menu_0524203345_0.menuBorderBgColor='#555555';

mm_menu_0524203345_0.bgColor='#555555';

window.mm_menu_0517110648_1 = new Menu("root",163,26,"Arial, Helvetica, sans-serif",13,"#000000","#f3f3f3","#d3d3d3","#999999","left","middle",3,0,1000,-5,7,true,false,true,0,false,false);

mm_menu_0517110648_1.addMenuItem("Mesa Diretora (2007/2008)","window.open('\mesa.htm', '_self');");

mm_menu_0517110648_1.addMenuItem("Conheça Todos","window.open('\conheca.htm', '_self');");

mm_menu_0517110648_1.hideOnMouseOut=true;

mm_menu_0517110648_1.menuBorder=0;

mm_menu_0517110648_1.menuLiteBgColor='#ffffff';

mm_menu_0517110648_1.menuBorderBgColor='#555555';

mm_menu_0517110648_1.bgColor='#555555';

mm_menu_0517110648_1.writeMenus();

} // mmLoadMenus()

//-->

</script>

</head>

<table width="774" border="0" cellpadding="0" cellspacing="0" bgcolor="#EFEAED" bo align="center">

<tr>

<font color="#8f0000" size="+3" face="Arial Narrow"><strong> </strong></font></p></td>

<td width="19"> </td>

</tr>

<tr>

<td height="90" colspan="3" valign="top"> <div align="center">

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="770" height="88">

<param name="movie" value="banner1.swf">

<param name="quality" value="high">

<embed src="../../../Inetpub/wwwroot/camara/httpdocs/banner1.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="770" height="88"></embed></object>

</div></td>

<td> </td>

</tr>

<tr>

<td width="157" height="227" valign="top"> <table border="0" cellpadding="0" cellspacing="0" width="141">

<tr>

<td><img src="../../../Inetpub/wwwroot/camara/httpdocs/Menu%20Principal/spacer.gif" alt="" name="undefined_2" width="3" height="1" border="0"></td>

<td><img src="../../../Inetpub/wwwroot/camara/httpdocs/Menu%20Principal/spacer.gif" alt="" name="undefined_2" width="1" height="1" border="0"></td>

</tr>

</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="150" height="1" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="1" border="0" alt=""></td>

</tr>

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="25" border="0" alt=""></td>

</tr>

<tr>

<td><img name="Menu_principal_r2_c1" src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/Menu_principal_r2_c1.gif" width="150" height="4" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="4" border="0" alt=""></td>

</tr>

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="26" border="0" alt=""></td>

</tr>

<tr>

<td><img name="Menu_principal_r4_c1" src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/Menu_principal_r4_c1.gif" width="150" height="4" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="4" border="0" alt=""></td>

</tr>

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="26" border="0" alt=""></td>

</tr>

<tr>

<td><img name="Menu_principal_r6_c1" src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/Menu_principal_r6_c1.gif" width="150" height="4" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="4" border="0" alt=""></td>

</tr>

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="26" border="0" alt=""></td>

</tr>

<tr>

<td><img name="Menu_principal_r8_c1" src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/Menu_principal_r8_c1.gif" width="150" height="4" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="4" border="0" alt=""></td>

</tr>

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="26" border="0" alt=""></td>

</tr>

<tr>

<td><img name="Menu_principal_r10_c1" src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/Menu_principal_r10_c1.gif" width="150" height="4" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="4" border="0" alt=""></td>

</tr>

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="26" border="0" alt=""></td>

</tr>

<tr>

<td><img name="Menu_principal_r12_c1" src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/Menu_principal_r12_c1.gif" width="150" height="4" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="4" border="0" alt=""></td>

</tr>

<tr>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="25" border="0" alt=""></td>

</tr>

<tr>

<td><img name="Menu_principal_r14_c1" src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/Menu_principal_r14_c1.gif" width="150" height="1" border="0" alt=""></td>

<td><img src="file:///C|/Inetpub/wwwroot/camara/httpdocs/menu Principal/spacer.gif" width="1" height="1" border="0" alt=""></td>

</tr>

</table></td>

<td width="12"> </td>

<td width="601" rowspan="4" valign="top"> <div align="center">

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td width="97%"><strong><font color="#990000"><%=(RsExibirNot.Fields.Item("titulo").Value)%></font></strong></td>

<td width="3%" rowspan="3"> </td>

</tr>

<tr>

<td> <br> <% if (RsExibirNot.Fields.Item("foto").Value<> "") Then %> <img src="<%=(RsExibirNot.Fields.Item("../../../Inetpub/wwwroot/camara/httpdocs/foto").Value)%>">

<% end if%> </tr>

<tr>

<td><div align="justify"><%=(RsExibirNot.Fields.Item("noticia").Value)%></div></td>

</tr>

</table>

</div></td>

<td> </td>

</tr>

<tr>

<td height="202" valign="top"> <table border="0" cellpadding="0" cellspacing="0" width="150">

<tr>

<td><img src="../../../Inetpub/wwwroot/camara/httpdocs/bt%20participe/spacer.gif" alt="" name="undefined_4" width="146" height="1" border="0"></td>

<td><img src="../../../Inetpub/wwwroot/camara/httpdocs/bt%20participe/spacer.gif" alt="" name="undefined_4" width="4" height="1" border="0"></td>

<td><img src="../../../Inetpub/wwwroot/camara/httpdocs/bt%20participe/spacer.gif" alt="" name="undefined_4" width="1" height="1" border="0"></td>

</tr>

<tr>

<td colspan="2" rowspan="2"><table border="0" cellpadding="0" cellspacing="0" width="150">

<tr>

<td><img src="bt participe/spacer.gif" alt="" name="undefined_4" width="146" height="1" border="0"></td>

<td><img src="bt participe/spacer.gif" alt="" name="undefined_4" width="4" height="1" border="0"></td>

<td><img src="bt participe/spacer.gif" alt="" name="undefined_4" width="1" height="1" border="0"></td>

</tr>

<tr>

<td rowspan="2"><img name="bt_participe_r1_c2" src="bt participe/bt_participe_r1_c2.gif" width="4" height="80" border="0" alt=""></td>

<td><img src="bt participe/spacer.gif" alt="" name="undefined_4" width="1" height="74" border="0"></td>

</tr>

<tr>

<td><img name="bt_participe_r2_c1" src="bt participe/bt_participe_r2_c1.gif" width="146" height="6" border="0" alt=""></td>

<td><img src="bt participe/spacer.gif" alt="" name="undefined_4" width="1" height="6" border="0"></td>

</tr>

</table></td>

<td><img src="../../../Inetpub/wwwroot/camara/httpdocs/bt%20participe/spacer.gif" alt="" name="undefined_4" width="1" height="74" border="0"></td>

</tr>

<tr>

<td><img src="../../../Inetpub/wwwroot/camara/httpdocs/bt%20participe/spacer.gif" alt="" name="undefined_4" width="1" height="6" border="0"></td>

</tr>

</table>

<form name="form1" method="post" action="">

<p align="center"> <font color="#990000" size="+3" face="Times New Roman, Times, serif">

Buscar</font>

<input name="busca" type="text" id="busca">

<br>

<input type="submit" name="Submit" value="Enviar">

</p>

</form></td>

<td> </td>

</tr>

<tr>

<td height="240" valign="top"><img src="Imagens/segur.png" width="157" height="240" align="top"></td>

<td> </td>

</tr>

<tr>

<td height="27" valign="top"> </td>

<td> </td>

</tr>

<tr>

<td height="0"></td>

<td></td>

</tr>

</table>

<table width="769" border="0" cellpadding="0" cellspacing="0">

</table>

</body>

</html>

<%

RsExibirNot.Close()

Set RsExibirNot = Nothing

end if

%>

************** tah ae o codigo inteiro tah cheio de erros no servidor o chato é que local foi numa boa!!

Agora tah exibindo a pagina e gerando esse erro

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/noticia.asp, line 229

acho que é no select

<td width="97%"><strong><font color="#990000"><%=(RsExibirNot.Fields.Item("titulo").Value)%></font></strong></td>

essa é a linha 229 mas o problema parece ser que naum tah retornando nada!

SE alguem puder me ajudar!!

vagner.net · Maio 27, 2007

Caramba Gabriel, é o sistema todo? RSRS...

Acho q o erro ta aqui:

if (Request.QueryString("cod"))<> "undefined" ThenRsExibirNot__MMColParam = Request.QueryString("cod")}

Fecha esse IF com ENF IF e não com }, assim:

if (Request.QueryString("cod"))<> "undefined" ThenRsExibirNot__MMColParam = Request.QueryString("cod")end if

OK..!!?? T+...

Gabriel Felipe · Maio 27, 2007

Valeu cara os problemas com end if eu jah tinha solucionado o problema é esse select que naum sei como pegar o dado que vem da pagina anterior cod e selecionar para abrir o banco por ele!!

vagner.net · Maio 27, 2007

Como eles vem da página anterior?Via GET(como parâmetro na URL) ou via POST(pelo form)?

Gabriel Felipe · Maio 27, 2007

Get

Gabriel Felipe · Maio 27, 2007

Microsoft VBScript runtime error '800a01a8' Object required: '25052007' /noticia.asp, line 21 Tá dando esse erro!! Eu consegui ler o que passa pelo get assim"SELECT * FROM noticia WHERE cod = '"+ RSExibirNot__MMColParam.replace() + "' ORDER BY cod DESC"mas ele da erro nessa linha msm naum sei pq !!

Gabriel Felipe · Maio 28, 2007

ALGUEM PODERIA ME AJUDAR A SOLUCIONAR ESSE PROBLEMA

**********

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/exclui.asp, line 72

*********

A Linha em negrito é a 72

*************

<%

var RSAltera = Server.CreateObject("ADODB.Recordset");

RSAltera.ActiveConnection = MM_Cadastro2_STRING;

RSAltera.Source = "SELECT * FROM noticia WHERE cod = '"+ RSAltera__MMColParam.replace(/'/g, "''") + "'";

RSAltera.CursorType = 0;

RSAltera.CursorLocation = 2;

RSAltera.LockType = 1;

RSAltera.Open();

var RSAltera_numRows = 0;

%>

Arquivado

Erro "ADODB.Recordset error '800a0bb9' "

Recommended Posts

Gabriel Felipe 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

vagner.net 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Gabriel Felipe 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

vagner.net 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Gabriel Felipe 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

vagner.net 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Gabriel Felipe 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

vagner.net 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Gabriel Felipe 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Gabriel Felipe 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Gabriel Felipe 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Fixar div até atingir uma certa altura

Ajuda com Extends e envio para o banco

PHP+Codeginiter - Orientação para Impressão

Fóruns

Tempo Real

Informação importante