Jump to content
Fórum Script Brasil
  • 0

Parâmetros Insuficientes

jucacabala

Asked by jucacabala,

 Share

Question

jucacabala

jucacabala

Posted
Posted

tenho uma pagina com um form com:

<form name="form1" method="post" action="resultado_satisfacao_cliente.asp">
          <tr> 
            <td width="200" rowspan="3" valign="top" class="arial10"><strong><font color="#005100">Selecione 
              a Planta ou Regi&atilde;o:</font></strong></td>
            <td width="10" rowspan="3">&nbsp;</td>
            <td><select name="id" class="box3" id="id">
                <option selected>Selecione</option>
                <option>-------------------------------</option>
                <option value="FSPC">Filial S&atilde;o Paulo</option>
                <option>-------------------------------</option>
                <option value="REG1">Regi&atilde;o 01</option>
                <option value="REG2">Regi&atilde;o 02</option>
                <option value="REG3">Regi&atilde;o 03</option>
                <option>-------------------------------</option>
                <option value="PHIG">Planta Higien&oacute;polis</option>
                <option value="PCTR">Planta Centro</option>
                <option value="PJBQ">Planta Jabaquara</option>
                <option value="PLIB">Planta Liberdade</option>
                <option value="PCSC">Planta Consola&ccedil;&atilde;o</option>
                <option value="TESC">Planta Escadas Rolantes</option>
                <option value="PPRS">Planta Para&iacute;so</option>
                <option value="PREP">Planta Rep&uacute;blica</option>
                <option value="PITM">Planta Itaim</option>
                <option value="PPLT">Planta Paulista</option>
                <option value="PTTP">Planta Tatuap&eacute;</option>
                <option value="PSTN">Planta Santana</option>
                <option value="PLAP">Planta Lapa</option>
                <option value="PMOM">Planta Moema</option>
                <option value="PBRN">Planta Berrini</option>
                <option value="PABC">Planta ABC</option>
                <option value="PMRB">Planta Morumbi</option>
              </select> </td>
          </tr>
          <tr> 
            <td>&nbsp;</td>
          </tr>
          <tr> 
            <td><input name="imageField" type="image" src="imagens/bt_consultar.gif" width="103" height="45" border="0"></td>
          </tr>
        </form>
na pagina resultado_satisfacao_cliente.asp tenho o codigo: 
<!-- #include file="conexao.inc" -->
<%
	DIM conexaodb, rs, str, str1
	id = Request.Form("id")
	Call AbreConexao
	str = "SELECT * FROM CstSatisfacao WHERE id = " & id
	Set rs = conexaodb.Execute(str)

%>

<html>
<head>
<title>Portal de Resultados do AA</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="estilo.css" rel="stylesheet" type="text/css">
<script language="JavaScript">
<!--
function MM_showHideLayers() { //v6.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
    obj.visibility=v; }
}

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[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
//-->
</script>
</head>

<body leftmargin="5" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="10" colspan="4" align="right"> <!--#include file="topo.asp" --></td>
  </tr>
  <tr> 
    <td colspan="4"><img src="imagens/transparente.gif" width="10" height="3"></td>
  </tr>
  <tr> 
    <td colspan="4" align="right"><a href="javascript:history.go(-1)"><img src="imagens/ico_volta.gif" width="67" height="30" border="0"></a>&nbsp;&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="4"><img src="imagens/tit_satisfacao_cliente.gif" width="268" height="52"></td>
  </tr>
  <tr> 
    <td colspan="4" valign="top"><img src="imagens/transparente.gif" width="11" height="9"></td>
  </tr>
  <tr> 
    <td colspan="4" class="arial10"><font color="#990000"><strong><% = rs.Fields("local") %>
      </strong></font></td>
  </tr>
  <tr> 
    <td colspan="4"><img src="imagens/transparente.gif" width="11" height="9"></td>
  </tr>
  <tr> 
    <td colspan="4" class="arial10">Clique sobre o m&ecirc;s para visualizar as 
      informa&ccedil;&otilde;es das pesquisas:</td>
  </tr>
  <tr> 
    <td colspan="4">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="4"><table width="100%" border="0" cellpadding="0" cellspacing="5" class="box2">
        <tr> 
          <td width="25%" align="center"><a href="#" id="titulo2" onClick="MM_showHideLayers('Layer1','','show')">janeiro</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2" onClick="MM_showHideLayers('Layer2','','show')">fevereiro</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2">mar&ccedil;o</a></td>
          <td width="25%" align="center"><a href="#" id="titulo3">acumulado 1&ordm; 
            trimestre</a></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td colspan="4">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="4"><table width="100%" border="0" cellpadding="0" cellspacing="5" class="box2">
        <tr> 
          <td width="25%" align="center"><a href="#" id="titulo2">abril</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2">maio</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2">junho</a></td>
          <td width="25%" align="center"><a href="#" id="titulo3">acumulado 2&ordm; 
            trimestre</a></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td colspan="4">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="4"><table width="100%" border="0" cellpadding="0" cellspacing="5" class="box2">
        <tr> 
          <td width="25%" align="center"><a href="#" id="titulo2">julho</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2">agosto</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2">setembro</a></td>
          <td width="25%" align="center"><a href="#" id="titulo3">acumulado 3&ordm; 
            trimestre</a></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td colspan="4">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="4"><table width="100%" border="0" cellpadding="0" cellspacing="5" class="box2">
        <tr> 
          <td width="25%" align="center"><a href="#" id="titulo2">outubro</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2">novembro</a></td>
          <td width="25%" align="center"><a href="#" id="titulo2">dezembro</a></td>
          <td width="25%" align="center"><a href="#" id="titulo3">acumulado 4&ordm; 
            trimestre</a></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td colspan="4">&nbsp;</td>
  </tr>
  <tr> 
    <td colspan="4"><table width="100%" border="0" cellpadding="0" cellspacing="5" bgcolor="#F2F2F2" class="box2">
        <tr> 
          <td width="25%" align="center"><a href="#" id="titulo3">ACUMULADO YTD</a></td>
          <td width="25%">&nbsp;</td>
          <td width="25%">&nbsp;</td>
          <td width="25%">&nbsp;</td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td height="300" colspan="4">&nbsp; </td>
  </tr>
  <tr> 
    <td colspan="4"> <!--#include file="rodape.asp" --> </td>
  </tr>
</table>
<div id="Layer1" style="position:absolute; width:99%; height:250px; z-index:1; left: 11px; top: 534px; visibility: hidden;"> 
  <table width="100%" border="0" cellpadding="0" cellspacing="5" bgcolor="#FFFFFF" class="box2">
    <tr> 
      <td colspan="9" align="right"><a href="#" onClick="MM_showHideLayers('Layer1','','hide')"><img src="imagens/bt_fechar.gif" width="100" height="30" border="0"></a></td>
    </tr>
    <tr> 
      <td colspan="9"><img src="imagens/transparente.gif" width="11" height="5"></td>
    </tr>
    <tr class="arial10"> 
      <td><strong><font color="#005500">Unidade</font></strong></td>
      <td align="center"><font color="#005500"><strong>Notas MS</strong></font></td>
      <td align="center"><font color="#005500"><strong>Notas MI+I</strong></font></td>
      <td align="center"><font color="#005500"><strong>Pesquisas Realizadas</strong></font></td>
      <td align="center"><font color="#005500"><strong>Clientes</strong></font></td>
      <td align="center"><font color="#005500"><strong>% MS</strong></font></td>
      <td align="center"><font color="#005500"><strong>Meta MS</strong></font></td>
      <td align="center"><font color="#005500"><strong>% MI+I</strong></font></td>
      <td align="center"><font color="#005500"><strong>Meta MI+I</strong></font></td>
    </tr>
    <%	str1 = str & " WHERE mês = 1"
  	Set rs = conexaodb.Execute(str1)
  	
  	Do While Not rs.EOF
    If bgColor = "#F2F2F2" Then
    	bgColor = "##BDCDD9"
    Else
    	bgColor = "#F2F2F2"
    End If
	%>
    <tr bgcolor="<%=bgColor%>"> 
      <td><% = rs.Fields("local") %></td>
      <td align="center"><% = rs.Fields("NotasMS") %></td>
      <td align="center"><% = rs.Fields("NotasMII") %></td>
      <td align="center"><% = rs.Fields("PesquisasRealizadas") %></td>
      <td align="center"><% = rs.Fields("Clientes") %></td>
      <td align="center"><% = rs.Fields("MS") %></td>
      <td align="center"><% = rs.Fields("MetaMS") %></td>
      <td align="center"><% = rs.Fields("MII") %></td>
      <td align="center"><% = rs.Fields("MetaMII") %></td>
    </tr>
    <%	rs.MoveNext
  Loop
  rs.Close
	%>
    <tr> 
      <td colspan="9"><img src="imagens/transparente.gif" width="11" height="5"></td>
    </tr>
  </table>
</div>
<div id="Layer2" style="position:absolute; width:99%; height:250px; z-index:1; left: 11px; top: 534px; visibility: hidden;"> 
  <table width="100%" border="0" cellpadding="0" cellspacing="5" bgcolor="#FFFFFF" class="box2">
    <tr> 
      <td colspan="9" align="right"><a href="#" onClick="MM_showHideLayers('Layer1','','hide')"><img src="imagens/bt_fechar.gif" width="100" height="30" border="0"></a></td>
    </tr>
    <tr> 
      <td colspan="9"><img src="imagens/transparente.gif" width="11" height="5"></td>
    </tr>
    <tr class="arial10"> 
      <td><strong><font color="#005500">Unidade</font></strong></td>
      <td align="center"><font color="#005500"><strong>Notas MS</strong></font></td>
      <td align="center"><font color="#005500"><strong>Notas MI+I</strong></font></td>
      <td align="center"><font color="#005500"><strong>Pesquisas Realizadas</strong></font></td>
      <td align="center"><font color="#005500"><strong>Clientes</strong></font></td>
      <td align="center"><font color="#005500"><strong>% MS</strong></font></td>
      <td align="center"><font color="#005500"><strong>Meta MS</strong></font></td>
      <td align="center"><font color="#005500"><strong>% MI+I</strong></font></td>
      <td align="center"><font color="#005500"><strong>Meta MI+I</strong></font></td>
    </tr>
    <%	str1 = str & " WHERE mês = 2"
  	Set rs = conexaodb.Execute(str1)
  	
  	Do While Not rs.EOF
    If bgColor = "#F2F2F2" Then
    	bgColor = "##BDCDD9"
    Else
    	bgColor = "#F2F2F2"
    End If
	%>
    <tr bgcolor="<%=bgColor%>"> 
      <td><% = rs.Fields("local") %></td>
      <td align="center"><% = rs.Fields("NotasMS") %></td>
      <td align="center"><% = rs.Fields("NotasMII") %></td>
      <td align="center"><% = rs.Fields("PesquisasRealizadas") %></td>
      <td align="center"><% = rs.Fields("Clientes") %></td>
      <td align="center"><% = rs.Fields("MS") %></td>
      <td align="center"><% = rs.Fields("MetaMS") %></td>
      <td align="center"><% = rs.Fields("MII") %></td>
      <td align="center"><% = rs.Fields("MetaMII") %></td>
    </tr>
    <%	rs.MoveNext
  Loop
  rs.Close
	%>
    <tr> 
      <td colspan="9"><img src="imagens/transparente.gif" width="11" height="5"></td>
    </tr>
  </table>
</div>

</body>
</html>

que ta dando o erro:

Tipo de erro:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

[Microsoft][Driver ODBC para Microsoft Access] Parâmetros insuficientes. Eram esperados 1.

dependendo do mes que ele clicar aparece na layer uma informação referente ao mes

so que ta dando esse erro

alguém sabe o motivo e como corrigir?

agradeço

julyana

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
dark0

dark0

Posted
Posted

salienta ae a linha do erro

mas, parece ser aqeles erros de variaveis vazias..

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
Go to question listing


  • Forum Statistics

    • Total Topics
      152.2k
    • Total Posts
      651.8k
×
×
  • Create New...