Busca

[deivitepopo]

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: sl@slboaventura.com.br</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

[.Andreia.]

você tem que colocar uma verificação pra saber se a palavra foi encontrada ou não, coloca a parte da consulta do banco aí

[deivitepopo]

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: sl@slboaventura.com.br</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: sl@slboaventura.com.br</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>

[.Andreia.]

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

[bareta]

so reporte algo quando for realmente valido