Jump to content
Fórum Script Brasil
  • 0

Busca


deivitepopo
 Share

Question

Pessoal to com um probleminha, tenho um cliente com uma busca no banco de dados em MDB, mas quando eu faço a busca ele não execulta corretamente da 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.

/comrovante_ipira.asp, line 94

ou fica mostrando apenas o primeiro registro no banco de dados. pessoal me da uma mão preciso disso com urgencia....

Segue o codigo abaixo:

<%@LANGUAGE="vb script:print();"><img src="imprimir.gif" alt="Imprimir" width="39" height="38" border="0"></a><br>

<br>

<br>

<br>

<br>

<br>

<br>

</p>

</DIV></TD>

</TR>

</TBODY>

</TABLE>

</TD>

</TR>

<TR vAlign=top>

<TD width=184> <TABLE cellSpacing=0 cellPadding=0 width=184 border=0>

<TBODY>

<TR>

<TD width=184></TR>

<TBODY>

<TR>

<TD vAlign=top background=ventura_arquivos/fundo111.jpg

height=8><IMG height=8 src="ventura_arquivos/bt.gif"

width=8></TD>

</TR>

<TR>

<TD background=ventura_arquivos/fundo111.jpg> <TABLE width=182 height=43 border=0 cellPadding=0 cellSpacing=0 bgcolor="#339900">

<TBODY>

<TR>

<TD width=182 height=43> <TABLE cellSpacing=0 cellPadding=0 width=169 border=0>

<TBODY>

<TR>

<TD width=39 height=34>&nbsp;</TD>

<TD width=130> <FORM style="DISPLAY: inline" name=clock

onsubmit=0>

<INPUT class=hora onfocus=blur()

readOnly name=face>

<script>startclock();</SCRIPT>

</FORM></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

<TR>

<TD background=ventura_arquivos/fundo111.jpg height=8><IMG

height=8 src="ventura_arquivos/bt.gif"

width=8></TD>

</TR>

</TBODY>

</TABLE></TD>

<TD width=10>&nbsp;</TD>

<TD width=367> <DIV align=center><FONT color=#666666 size=2>SLBOAVENTURA<BR>

TEL: 75-3614-4839<BR>

Feira de Santana - Ba, CEP: 44025-101<BR>

E-mail: [email protected]</FONT></DIV></TD>

<TD width=9>&nbsp;</TD>

<TD width=190> <TABLE cellSpacing=0 cellPadding=0 width=184 border=0>

<TBODY>

<TR>

<TD width=184 height=8><IMG height=8

src="ventura_arquivos/bt.gif" width=8></TD>

</TR>

<TR>

<TD align=middle height=0> <script language=JavaScript>

<!--

d=document;

bs = "http://aovivo.terra.com.br/noticias/aovivo/bradesco/bradesco051005.swf",bg = "http://ad.doubleclick.net/834923/selo2_120x60_terra_bradescompleto_carametade_050729.gif",bu = "http://ad.doubleclick.net/clk;21917499;8583118;x?http://www.bradescompleto.com.br/invest",bu = escape(bu),bw = 120,bh = 60,bm = "opaque",bu2 = ("%u" != "")?"http://ad.doubleclick.net/clk;18965370;8583118;u?http://www.bradescompleto.com.br/completo":"http://ad.doubleclick.net/clk;18965370;8583118;u?http://www.bradescompleto.com.br/invest";

pv=6,po=false,nv=navigator,nm=nv.mimeTypes,ug=nv.userAgent,pg=(nm&&nm["application/x-shockwave-flash"])?nm["application/x-shockwave-flash"].enabledPlugin:0;

if(pg){w = nv.plugins["Shockwave Flash"].description.split(" ");

for (var i = 0; i < w.length; ++i){ if (isNaN(parseInt(w)))continue;pv2 = w;}po = pv2 >= pv;}

else if(ug && ug.indexOf("MSIE")>=0&&(nv.appVersion.indexOf("Win")!= -1)){

d.write('<SCR' + 'IPT LANGUAGE=VBScript\> \n');d.write('on error resume next \n');d.write('po = (IsObject(CreateObject("ShockwaveFlash.ShockwaveFlash." & pv)))\n');d.write('</SCR' + 'IPT\> \n');

}

na = nv.appName;

if(po){

d.write('<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=3,0,0,0" width="'+ bw +'" height="'+ bh +'"><param name=movie value="' + bs + '?clicktag='+ bu +'"><param name=quality value=autohigh><param name=menu value=false><param name=bgcolor><param name=wmode value='+ bm +'><embed src="' + bs + '?clickTag='+ bu +'" quality=autohigh width="'+ bw +'" height="'+ bh +'" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>');

} else if (!(na && na.indexOf("Netscape")>=0 && nv.appVersion.indexOf("2.")>=0)){

d.write('<a target="_blank" href="' + bu2 + '"><img src="' + bg + '" border=0></a>');

}

//-->

</SCRIPT> </TD>

Deivite Popo

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Pessoal to com um probleminha, tenho um cliente com uma busca no banco de dados em MDB, mas quando eu faço a busca ele não execulta corretamente da 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.

/comrovante_ipira.asp, line 94

ou fica mostrando apenas o primeiro registro no banco de dados. pessoal me da uma mão preciso disso com urgencia....

Segue o codigo abaixo:

<%@LANGUAGE="vb script:print();"><img src="imprimir.gif" alt="Imprimir" width="39" height="38" border="0"></a><br>

<br>

<br>

<br>

<br>

<br>

<br>

</p>

</DIV></TD>

</TR>

</TBODY>

</TABLE>

</TD>

</TR>

<TR vAlign=top>

<TD width=184> <TABLE cellSpacing=0 cellPadding=0 width=184 border=0>

<TBODY>

<TR>

<TD width=184></TR>

<TBODY>

<TR>

<TD vAlign=top background=ventura_arquivos/fundo111.jpg

height=8><IMG height=8 src="ventura_arquivos/bt.gif"

width=8></TD>

</TR>

<TR>

<TD background=ventura_arquivos/fundo111.jpg> <TABLE width=182 height=43 border=0 cellPadding=0 cellSpacing=0 bgcolor="#339900">

<TBODY>

<TR>

<TD width=182 height=43> <TABLE cellSpacing=0 cellPadding=0 width=169 border=0>

<TBODY>

<TR>

<TD width=39 height=34>&nbsp;</TD>

<TD width=130> <FORM style="DISPLAY: inline" name=clock

onsubmit=0>

<INPUT class=hora onfocus=blur()

readOnly name=face>

<script>startclock();</SCRIPT>

</FORM></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

<TR>

<TD background=ventura_arquivos/fundo111.jpg height=8><IMG

height=8 src="ventura_arquivos/bt.gif"

width=8></TD>

</TR>

</TBODY>

</TABLE></TD>

<TD width=10>&nbsp;</TD>

<TD width=367> <DIV align=center><FONT color=#666666 size=2>SLBOAVENTURA<BR>

TEL: 75-3614-4839<BR>

Feira de Santana - Ba, CEP: 44025-101<BR>

E-mail: [email protected]</FONT></DIV></TD>

<TD width=9>&nbsp;</TD>

<TD width=190> <TABLE cellSpacing=0 cellPadding=0 width=184 border=0>

<TBODY>

<TR>

<TD width=184 height=8><IMG height=8

src="ventura_arquivos/bt.gif" width=8></TD>

</TR>

<TR>

<TD align=middle height=0> <script language=JavaScript>

<!--

d=document;

bs = "http://aovivo.terra.com.br/noticias/aovivo/bradesco/bradesco051005.swf",bg = "http://ad.doubleclick.net/834923/selo2_120x60_terra_bradescompleto_carametade_050729.gif",bu = "http://ad.doubleclick.net/clk;21917499;8583118;x?http://www.bradescompleto.com.br/invest",bu = escape(bu),bw = 120,bh = 60,bm = "opaque",bu2 = ("%u" != "")?"http://ad.doubleclick.net/clk;18965370;8583118;u?http://www.bradescompleto.com.br/completo":"http://ad.doubleclick.net/clk;18965370;8583118;u?http://www.bradescompleto.com.br/invest";

pv=6,po=false,nv=navigator,nm=nv.mimeTypes,ug=nv.userAgent,pg=(nm&&nm["application/x-shockwave-flash"])?nm["application/x-shockwave-flash"].enabledPlugin:0;

if(pg){w = nv.plugins["Shockwave Flash"].description.split(" ");

for (var i = 0; i < w.length; ++i){ if (isNaN(parseInt(w)))continue;pv2 = w;}po = pv2 >= pv;}

else if(ug && ug.indexOf("MSIE")>=0&&(nv.appVersion.indexOf("Win")!= -1)){

d.write('<SCR' + 'IPT LANGUAGE=VBScript\> \n');d.write('on error resume next \n');d.write('po = (IsObject(CreateObject("ShockwaveFlash.ShockwaveFlash." & pv)))\n');d.write('</SCR' + 'IPT\> \n');

}

na = nv.appName;

if(po){

d.write('<object classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=3,0,0,0" width="'+ bw +'" height="'+ bh +'"><param name=movie value="' + bs + '?clicktag='+ bu +'"><param name=quality value=autohigh><param name=menu value=false><param name=bgcolor><param name=wmode value='+ bm +'><embed src="' + bs + '?clickTag='+ bu +'" quality=autohigh width="'+ bw +'" height="'+ bh +'" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>');

} else if (!(na && na.indexOf("Netscape")>=0 && nv.appVersion.indexOf("2.")>=0)){

d.write('<a target="_blank" href="' + bu2 + '"><img src="' + bg + '" border=0></a>');

}

//-->

</SCRIPT> </TD>

Deivite Popo

Segue parte da consulta:

<%@LANGUAGE="VBSCRIPT"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

HTML><HEAD><TITLE>Slboaventura</TITLE>

<META http-equiv=Content-Type content="text/html; charset=iso-8859-1"><LINK

href="ventura_arquivos/estilos.css" type=text/css rel=stylesheet>

<script language=JavaScript src="ventura_arquivos/base.js"></SCRIPT>

<META content="MSHTML 6.00.2800.1106" name=GENERATOR>

<script language=JavaScript type=text/JavaScript>

<!--

function MM_reloadPage(init) { //reloads the window if Nav4 resized

if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {

document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}

else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();

}

MM_reloadPage(true);

//-->

</SCRIPT>

</HEAD>

<BODY bgColor=#ffffff leftMargin=0 background=ventura_arquivos/fundo111.jpg

topMargin=0 marginheight="0" marginwidth="0">

<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>

<TBODY>

<TR>

<TD width=760></TD>

</TR>

<TBODY>

<TR>

<TD vAlign=top background=ventura_arquivos/faxada_760.jpg height=124> <DIV align=center>

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

<tr>

<td width="65%" height="182"> <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="496" height="177">

<param name="movie" value="ventura_arquivos/flash/faixada.swf">

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

<embed src="ventura_arquivos/flash/faixada.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="496" height="177"></embed></object>

</td>

<td width="35%"><img src="ventura_arquivos/imagens/inscricoes_abert.gif" width="265" height="182"></td>

</tr>

</table>

</DIV></TD>

</TR>

<TR>

<TD vAlign=top> <TABLE cellSpacing=0 cellPadding=0 width=760 border=0>

<TBODY>

<TR vAlign=top>

<TD bgColor=#f8f8f8 colSpan=5 height=115> <TABLE width="68%" align="center" cellPadding=0 cellSpacing=0>

<TBODY>

<TR>

<TD height=308>

<DIV align=center>

<form name="form1" method="post" action="comrovante_ipira.asp">

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

<tr>

<td colspan="3"><div align="center"><font size="5">

Ficha de inscri&ccedil;&atilde;o</font></div></td>

</tr>

<tr>

<td width="18%" height="26">&nbsp;</td>

<td width="48%">&nbsp;</td>

<td width="34%">&nbsp;</td>

</tr>

<tr>

<td><font size="2">CPF:</font></td>

<td><input name="consult" type="text" id="consult" size="20" maxlength="40"></td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td>&nbsp;</td>

<td>&nbsp;</td>

</tr>

<tr>

<td>&nbsp;</td>

<td><input type="submit" name="Submit" value="Consultar"></td>

<td>&nbsp;</td>

</tr>

</table>

</form>

<p><br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

</p>

</DIV></TD>

</TR>

</TBODY>

</TABLE>

</TD>

</TR>

<TR vAlign=top>

<TD width=184> <TABLE cellSpacing=0 cellPadding=0 width=184 border=0>

<TBODY>

<TR>

<TD width=184></TR>

<TBODY>

<TR>

<TD vAlign=top background=ventura_arquivos/fundo111.jpg

height=8><IMG height=8 src="ventura_arquivos/bt.gif"

width=8></TD>

</TR>

<TR>

<TD background=ventura_arquivos/fundo111.jpg> <TABLE width=182 height=43 border=0 cellPadding=0 cellSpacing=0 bgcolor="#339900">

<TBODY>

<TR>

<TD width=182 height=43> <TABLE cellSpacing=0 cellPadding=0 width=169 border=0>

<TBODY>

<TR>

<TD width=39 height=34>&nbsp;</TD>

<TD width=130> <FORM style="DISPLAY: inline" name=clock

onsubmit=0>

<INPUT class=hora onfocus=blur()

readOnly name=face>

<script>startclock();</SCRIPT>

</FORM></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

<TR>

<TD background=ventura_arquivos/fundo111.jpg height=8><IMG

height=8 src="ventura_arquivos/bt.gif"

width=8></TD>

</TR>

</TBODY>

</TABLE></TD>

<TD width=10>&nbsp;</TD>

<TD width=367> <DIV align=center><FONT color=#666666 size=2>SLBOAVENTURA<BR>

TEL: 75-3614-4839<BR>

Feira de Santana - Ba, CEP: 44025-101<BR>

E-mail: [email protected]</FONT></DIV></TD>

<TD width=9>&nbsp;</TD>

<TD width=190> <TABLE cellSpacing=0 cellPadding=0 width=184 border=0>

<TBODY>

<TR>

<TD width=184 height=8><IMG height=8

src="ventura_arquivos/bt.gif" width=8></TD>

</TR>

<TR>

<TD align=middle height=0> <script language=JavaScript>

<!--

d=document;

bs = "http://aovivo.terra.com.br/noticias/aovivo/bradesco/bradesco051005.swf",bg = "http://ad.doubleclick.net/834923/selo2_120x60_terra_bradescompleto_carametade_050729.gif",bu = "http://ad.doubleclick.net/clk;21917499;8583118;x?http://www.bradescompleto.com.br/invest",bu = escape(bu),bw = 120,bh = 60,bm = "opaque",bu2 = ("%u" != "")?"http://ad.doubleclick.net/clk;18965370;8583118;u?http://www.bradescompleto.com.br/completo":"http://ad.doubleclick.net/clk;18965370;8583118;u?http://www.bradescompleto.com.br/invest";

pv=6,po=false,nv=navigator,nm=nv.mimeTypes,ug=nv.userAgent,pg=(nm&&nm["application/x-shockwave-flash])?nm["application/x-shockwave-flash"].enabledPlugin:0;

if(pg){w = nv.plugins["Shockwave Flash"].description.split(" ");

for (var i = 0; i < w.length; ++i){ if (isNaN(parseInt(w)))continue;pv2 = w;}po = pv2 >= pv;}

else if(ug && ug.indexOf("MSIE")>=0&&(nv.appVersion.indexOf("Win")!= -1)){

d.write('<SCR' + 'IPT LANGUAGE=VBScript\> \n');d.write('on error resume next \n');d.write('po = (IsObject(CreateObject("ShockwaveFlash.ShockwaveFlash." & pv)))\n');d.write('</SCR' + 'IPT\> \n');

}

na = nv.appName;

if(po){

d.write('<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=3,0,0,0" width="'+ bw +'" height="'+ bh +'"><param name=movie value="' + bs + '?clicktag='+ bu +'"><param name=quality value=autohigh><param name=menu value=false><param name=bgcolor><param name=wmode value='+ bm +'><embed src="' + bs + '?clickTag='+ bu +'" quality=autohigh width="'+ bw +'" height="'+ bh +'" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>');

} else if (!(na && na.indexOf("Netscape")>=0 && nv.appVersion.indexOf("2.")>=0)){

d.write('<a target="_blank" href="' + bu2 + '"><img src="' + bg + '" border=0></a>');

}

//-->

</SCRIPT> </TD>

</TR>

<TR>

<TD height=0><IMG height=8 src="ventura_arquivos/bt.gif"

width=8></TD>

</TR>

<TR>

<TD>&nbsp; </TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

</TBODY>

</TABLE>

<MAP

name=Map><AREA shape=RECT target=_blank

alt="Desenvolvido por Neutra Soluções Web" coords=701,22,751,41

href="http://www.neutra.com.br/"></MAP><MAP name=Map2><AREA shape=RECT

target=conteudo coords=482,32,572,57

href="http://www.netcarveiculos.com.br/financiamentos.asp"><AREA shape=RECT

target=conteudo coords=10,35,77,57

href="http://www.netcarveiculos.com.br/capa.asp"><AREA shape=RECT

target=conteudo coords=667,35,747,59

href="http://www.netcarveiculos.com.br/faleconosco.asp"></MAP></BODY></HTML>

Link to comment
Share on other sites

  • 0

não abra tópico repetido, aquele que você abriu igual ao seu ultimo tópico deletei.

Cade a tua consulta ao banco???? Bom o que eu quero dizer é (EXEMPLO):

sql = "select * from TABELA"

set tab = conexao.execute(sql)

if tab.eof then

response.write "a busca retornou sem resultados"

response.end

end if

while not tab.eof

'exibe resultado

tab.movenext

wend

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



  • Forum Statistics

    • Total Topics
      151k
    • Total Posts
      649.1k
×
×
  • Create New...