[Resolvido] Erro ao Excluir Registro

fabio Avila · Julho 23, 2009

Ola AMigos

Desculpa a incistencia , mas não to conseguindo achar o erro nesse codigo ,continua dando erro :

(0x800A01A8)

Objeto necessário: ''

/asp/acisc/apaga_main.asp, line 8

Desde já agradeço a força que estão me dando ... segue abaixo o codigo


<%
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("contato.mdb") & ";Persist Security Info=False"
autonum= Request.QueryString("autonum")
sql = "DELETE FROM Juridico WHERE autonum= "&autonum

Set ObjRs = objConn.Execute(sql)
objCon.Close

Set objCon= Nothing

%>

vlw

Mário Monteiro · Julho 23, 2009

tire o recordset

deixe apenas

<%
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("contato.mdb") & ";Persist Security Info=False"
autonum= Request.QueryString("autonum")
sql = "DELETE FROM Juridico WHERE autonum= "&autonum
objCon.Execute(sql)
objCon.Close
Set objCon = Nothing
%>

e veja que mais uma vez estava usando objConn de forma escrita errada no execute

Salgado · Julho 23, 2009

Verifique também o link que leva para a execução, aparentemente há um erro na concatenação dos dados e está levando texto junto com o ID a ser excluído.

xanburzum · Julho 23, 2009

olha eu tenho uma aplicacaun que 1º exibe tdos os dados com a opcaun de excluir e atualizar , onde o user clicnado no link excluir por exemplo é passado o dados no link assim:

<A HREF="excluir_form.asp?codigo=<%=rs("codigo")%>">Excluir</A>

ao clicar no link , é recuperado o valor da querystring, depois é exibido os dados antes de excluir, para o user ver o k esta sendo excluido e finalmente executa o DELETE do SQL.

no seu delete, passe assim:

SQL="DELETE FROM Juridico WHERE autonum ="&autonum&""

e de um response.write na sua string SQL para ver o k esta sendo passado

response.write(SQL)
response.end()

fabio Avila · Julho 23, 2009

E ae beleza..

Fiz as alterações mas ainda continua o erro :

Erro de sintaxe na seqüência de caracteres na expressão de consulta 'autonum= 72">Deletar Cadastro</a>'.

/asp/acisc/apaga_main.asp, line 7

Segue meu codigo que pega os dados para excluir na pagina de cadastro :

apaga_main.asp?Deletar=cadastro&autonum=<%=autonum%>">Deletar Cadastro</a>

Codigo que apaga:

<HTML><HEAD><TITLE>excluir_2.asp</TITLE><body bgcolor="aqua"></HEAD>
<%
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("contato.mdb") & ";Persist Security Info=False"
autonum= Request.QueryString("autonum")
sql = "DELETE FROM Juridico WHERE autonum= "&autonum
objCon.Execute(sql)
objCon.Close
Set objCon = Nothing
%>
 <!-- depois de enviado o email... --><script language="JavaScript">alert('Cadastro excluido com sucesso!');location.href='teste.asp';</script>            </BODY></HTML>
 
 <BR>

Mário Monteiro · Julho 23, 2009

qual a linha completa do link que ta dando erro?

xanburzum · Julho 23, 2009

recupera ele assim

autonum= Trim(Request.QueryString("autonum"))

sql = "DELETE FROM Juridico WHERE autonum="&autonum&""

lembre-se k no bd ele precisa estar com numerico tb

fabio Avila · Julho 23, 2009

Ola ,

O erro esta na linha objCon.Execute(sql), e o campo autonum é autonumerico ...

Vlw

xanburzum · Julho 24, 2009

na verdade o erro é na string sql sua...

faz isso..

autonum= Trim(Request.QueryString("autonum")) 
sql = "DELETE FROM Juridico WHERE autonum="&autonum&""
response.write autonum
response.end()

para ver o k esta sendo resgatado,

pois a instrucao sql esta correta, ou naun existe o id k esta sendo passado

Mário Monteiro · Julho 24, 2009

mas o erro que acusou la em cima era outro

post o erro que aparece pois você não está sendo claro

fabio Avila · Julho 24, 2009

dei o comando e regastou 361">Deletar Cadastro , esse id existem sim.. e agora oq mais posso fazer ..

Mário Monteiro · Julho 24, 2009

post a linha que gera este link

fabio Avila · Julho 24, 2009

Mario , vou postar o arquivo que mostra os dados dos clientes e o que faz a exclusão ,

<!--#include file="conexao2.asp" -->

<%



'==================================================================
'Arquivo para cadastro de ACABAMENTO.
'Autor: Fabio P Avila - 7-02-2008
'
'==================================================================

acao 	= Request("acao")
autonum = Request("autonum")
 

	if acao = "V" then
		disabilita = " disabled=""disabled"" " 
	elseif acao = "A" then
		disabilita = ""
	end if
	
	'Dados Alterar
	autonum= Request("autonum")
	
	if (acao = "A" or acao = "V") then	
		
		if acao = "A" then
		   acao = "alterar"
		   bt   = "Alterar" 
		else
		   acao = "visualizar"
		   bt   = "Alterar"
		end if
	
		set rs2 = Server.CreateObject("ADODB.Recordset")
		sql2    = "select * from Juridico where autonum="&autonum&""
		set rs2 = objCon.execute(sql2)
	
	'-------------------------------------------------
	'	Estes dados podem ser alterados
		Associado    = rs2("Associado")
		devedor    = rs2("devedor")
	    andamento   = rs2("andamento")
	    valor    = rs2("valor")
	    serasa   = rs2("serasa")
	    datainclusao = rs2("datainclusao")
	    datacordo = rs2("datacordo")
	    valoracordo = rs2("valoracordo")
	    quitacao = rs2("quitacao")
	    valorpagamento = rs2("valorpagamento")
	    documento   = rs2("documento")
		autonum    = rs2("autonum")
	
	

			
	'--------------------------------------------------
	else
		acao = "gravar"
		bt   = "Gravar"
	end if

	bt = Ucase(bt)

%>


<body bgcolor="#E4E4E4">

<center>

<TITLE>:. Fgcom Controle de Associaddos v1.0 :.</TITLE>
<link href="estilos.css" rel="stylesheet" type="text/css" />


<script language="JavaScript">
<!--
window.defaultStatus=":: ACISC ::"
// -->
</script>
<TABLE cellSpacing=0 cellPadding=0 width=774 align=center 
  <TR>
    <TD align=middle valign="top" bgcolor="#FFFFFF" height="97" style="font-family: VPSA online system">



<TABLE cellSpacing=0 cellPadding=0 width=523 align=center 
background="../Sites/etiq/VPSA%20TECNOLOGIA%20E%20INFORMÁTICA%20LTDA_arquivos/back_temp.gif" 
  border=0 height="1">
  <TR>
    <TD align=middle valign="top" bgcolor="#EFEFEF" height="47" style="font-family: VPSA online system" width="810">
      <b>
                      <font face="Tahoma" style="font-size: 12pt">
                      <img border="0" src="inclusao_juridico.jpg" width="799" height="70"></font></b></TD></TR>
  <TR>
    <TD align=middle bgcolor="#EFEFEF" height="22" style="font-family: VPSA online system" width="810">
      <p align="right">

	 </TD>
    </TR>
  <tr>
    <TD align=middle bgcolor="#EFEFEF" height="1" style="font-family: VPSA online system" valign="middle" width="810">
<p align="center"><font face="Tahoma" color="#008000">
<span style="font-size: 12pt; font-weight: 700">Cadastro de Inclusões</span></font><hr></TD>
    </tr>
  <tr>
                    <td width="806" bgcolor="#EFEFEF" height="1" style="border-style:none; border-width:medium; " valign="top">
                      <form method="GET" action="alterar_teste.asp" name="form">
<div align="center">
  <center>
<table border="0" cellpadding="0" width="803" height="1" style="border-collapse: collapse" bordercolor="#111111" cellspacing="0">
  <tr>
    <td width="273" height="10" bgcolor="#EFEFEF" style="border-style: none; border-width: medium">
 </td>
    <td width="767" colspan="5" height="10" bgcolor="#EFEFEF" style="border-style: none; border-width: medium">
 </td>
  </tr>
  <tr>
    <td width="4573" colspan="11" height="11" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="12" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="12" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="12" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="12" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">ID</font></b></td>
    <td width="2124" colspan="6" height="12" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p align="left">
<b><font face="Tahoma" color="#FFFFFF">
<INPUT id=email5 maxLength=40 name=autonum 
            style="border:1px solid #000000; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1; font-family:Tahoma" size="9" value="<%=autonum%>"></font></b></td>
    <td width="889" height="12" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<p>
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">Empresa</font></b></td>
    <td width="2124" colspan="6" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p align="left">
<font face="Tahoma"><span style="font-size: 8pt">
<input name="Associado" type="text" class="inputSelecionado" value="<%=Associado%>" size="75" maxlength="30" <%=disabilita%> style="border:1px solid #000000; font-size: 8 pt; font-family: Tahoma; background-color:#A1C094"></span></font></td>
    <td width="889" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="11" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="11" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="11" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="11" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<p><b><font face="Tahoma" style="font-size: 8pt" color="#008000">
Devedor:</font></b></td>
    <td width="2124" colspan="6" height="11" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<b><font face="Tahoma" color="#FFFFFF">
<INPUT id=email4 maxLength=40 name=devedor 
            style="border:1px solid #000000; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1; font-family:Tahoma" size="61" value="<%=devedor%>"></font></b></td>
    <td width="889" height="11" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="670" valign="middle" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" colspan="4">
<p align="right"><b><font face="Tahoma" style="font-size: 8pt" color="#008000">
Inclusão:</font></b></td>
    <td width="2223" valign="top" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" colspan="6">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<INPUT id=email2 maxLength=60 name=datainclusao 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="10" value="<%=datainclusao%>"></font></b></font></td>
    <td width="857" valign="top" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<p align="left">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">Documento: 
</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="12" --><INPUT class=botao id=senha2 maxLength=12 name=documento 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="16" value="<%=documento%>"></font></b></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">Valor:</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="12" --><INPUT class=botao id=senha2 maxLength=12 name=valor 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="11" value="<%=valor%>"></font></b></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">SCPC:</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="12" --><INPUT class=botao id=senha2 maxLength=12 name=serasa 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="10" value="<%=serasa%>"></font></b></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="852" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094" colspan="2" align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">  Data 
Acordo:</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="12" --><INPUT class=botao id=senha2 maxLength=12 name=datacordo 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="11" value="<%=datacordo%>"></font></b></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="852" height="1" valign="middle" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094" colspan="2" align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">  Valor  
Acordo:</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="12" --><INPUT class=botao id=senha2 maxLength=12 name=valoracordo 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="11" value="<%=valoracordo%>"></font></b></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094" align="left">
 </td>
    <td width="438" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">Valor Pago:</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="12" --><INPUT class=botao id=senha2 maxLength=12 name=valorpagamento 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="5" value="<%=valorpagamento%>"></font></b></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">Quitação:</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font face="Tahoma"><b><font color="#008000">
<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="12" --><INPUT class=botao id=senha2 maxLength=12 name=quitacao 
            style="border-style:solid; border-width:1; BACKGROUND-COLOR: #A1C094; FONT-SIZE: 8 pt; font-family:Tahoma; padding-left:4; padding-right:4; padding-top:1; padding-bottom:1" size="5" value="<%=quitacao%>"></font></b></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="459" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="414" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="438" height="1" valign="middle" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" align="right">
<b><font face="Tahoma" style="font-size: 8pt" color="#008000">Andamento:</font></b></td>
    <td width="728" colspan="3" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top:0; margin-bottom:0">
<font size="2" face="Verdana" style="font-size: 8pt" color="#FFFFFF">
<textarea cols="88" name="Andamento" rows="7" style="border:1px solid #000000; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; font-size:8 pt; font-family:Tahoma; color:#000000; background-color:#A1C094"><%=Andamento%></textarea></font></td>
    <td width="476" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="464" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="460" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p style="margin-top: 0; margin-bottom: 0"> </td>
    <td width="889" height="1" valign="top" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="3355" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" colspan="11">
 </td>
  </tr>
  <tr>
    <td width="3355" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094" colspan="11">
<hr color="#A1C094" noshade>
<div style="border-right: 1px solid #A1C094">
 </div>
    </td>
  </tr>
  <tr>
    <td width="272" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="271" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="226" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="282" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="615" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094" valign="middle">
                    <p align="center">
                    <font face="Tahoma"><span style="font-size: 8pt"> 
                                                                         
                    <input type="submit" value="Alterar" name="enviar" style="font-size: 8 pt; font-family: Tahoma; font-weight: bold; background-color: #A1C094">   </span></font></td>
    <td width="160" height="1" valign="middle" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p align="left">
                    <font face="Tahoma"><span style="font-size: 8pt"> 
                         
                    <input type="button" value="Excluir" name="Voltar" OnClick="location.href='apaga_main.asp?autonum=<%=autonum%>';"  style="font-size: 8 pt; font-family: Tahoma; font-weight: bold; background-color: #A1C094; color:#000000; background-image:url('fundo2.jpg')"> </span></font></td>
    <td width="150" height="1" valign="middle" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">

	<span class="nobr">
	<span style="font-size: 8pt"><font face="Tahoma">
	<b>
	       </b></font></span></span>
                    <font face="Tahoma"><span style="font-size: 8pt"> 
                    <input type="button" value="Imprimir" name="Imprimir" OnClick="javascript:DoPrinting()" style="font-size: 8 pt; font-family: Tahoma; font-weight: bold; background-color: #A1C094"></span></font><a href="apaga_main.asp?Deletar=cadastro&autonum=<%=autonum%>">Deletar Cadastro</a>">clique 
    aqui para apagar</a></td>
    <td width="304" height="1" valign="middle" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
<p align="center">
                     </td>
    <td width="292" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="288" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif" bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="717" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="272" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="271" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="226" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="282" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="615" height="1" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="34" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="276" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="304" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="292" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="288" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
    <td width="717" height="1" valign="bottom" style="border-style:none; border-width:medium; font-size: 9px; font-family: Verdana, Arial, Helvetica, sans-serif; " bgcolor="#EFEFEF" bordercolor="#A1C094">
 </td>
  </tr>
  <tr>
    <td width="58" height="1" style="border-top-style: none; border-top-width: medium">
    </td>
    <td width="1" height="1" style="border-top-style: none; border-top-width: medium">
    </td>
    <td width="465" height="1" colspan="2" style="border-top-style: none; border-top-width: medium">
    </td>
    <td width="54" height="1" colspan="2">
    </td>
    <td width="446" height="1" style="border-top-style: none; border-top-width: medium">
    </td>
  </tr>
  <tr>
    <td width="58" valign="top" height="1">
    </td>
    <td width="1" valign="top" height="1">
    </td>
    <td width="308" valign="top" height="1" colspan="4">
    </td>
    <td width="446" valign="top" height="1">
    </td>
  </tr>
  <tr>
    <td align="center" width="434" height="1">
    </td>
    <td align="center" width="370" height="1">
    </td>
    <td align="center" width="852" colspan="5" height="1">
    </td>
  </tr>
  <tr>
    <td align="center" width="1386" valign="middle" height="1">
    </td>
    <td align="center" width="1222" valign="middle" colspan="6" height="1">
<p>
    </td>
  </tr>
</table>
  </center>
</div>
<input type="hidden" name="autonum" value="<%=autonum%>">
</form>
</td> 
              </tr>
  <TR>
    <TD align=middle bgcolor="#E3E0DB" height="1" style="font-family: VPSA online system" width="810">
      </p>
</center>
</TD>
    </TR></TABLE>
    </TD></TR>
  </TABLE>

Agora vai o de exclusão , o erro permasse na linha que executa o sql (linha7), erro de Erro de sintaxe na seqüência de caracteres na expressão de consulta

<%
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("contato.mdb") & ";Persist Security Info=False"
autonum= Trim(Request.QueryString("autonum"))
 sql = "DELETE FROM Juridico WHERE autonum="&autonum&""
objCon.Execute(sql)

objCon.Close
Set objCon = Nothing
%>

vlw

Mário Monteiro · Julho 24, 2009

seu codigo está assim mesmo?

<a href="apaga_main.asp?Deletar=cadastro&autonum=<%=autonum%>">Deletar Cadastro</a>">

corrija isso

fabio Avila · Julho 24, 2009

o link esta :

apaga_main.asp?Deletar=cadastro&autonum=<%=autonum%>">Deletar Cadastro</a>

Mário Monteiro · Julho 24, 2009

fabio

precisamos definir uma estrategia de resolver rápido seu problema

para tanto os seus posts precisam ser melhor aproveitados

pois a cada post você diz algo diferente do anterior e fica difícil adivinharmos o que realmente está havendo

para começar, sempre a partir de então post o erro atual e a linha de código completa que ele está

não é para postar o código todo só a linha se precisarmos de mais código te avisamos o quando de código é necessário

entendeu?

erro atual e linha de código completa que ele se encontra

fabio Avila · Julho 24, 2009

mario,

foi mal ae apenas achei q entendia melhor se postasse o codigo todo , vamos denovo erro atual :

Erro de sintaxe na seqüência de caracteres na expressão de consulta

linha do erro:

objCon.Execute(sql)

vlw

Salgado · Julho 24, 2009

mario,

foi mal ae apenas achei q entendia melhor se postasse o codigo todo , vamos denovo erro atual :
Erro de sintaxe na seqüência de caracteres na expressão de consulta
linha do erro:
objCon.Execute(sql)
vlw

Ok,

Agora substitua esse trecho:

<%
Set objCon = Server.CreateObject("ADODB.Connection")

objCon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("contato.mdb") & ";Persist Security Info=False"

autonum= Trim(Request.QueryString("autonum"))

sql = "DELETE FROM Juridico WHERE autonum="&autonum&""

objCon.Execute(sql)

objCon.Close

Set objCon = Nothing

%>

Por esse e poste o resultado:

<%
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("contato.mdb") &";Persist Security Info=False"
autonum= Trim(Request.QueryString("autonum"))
sql = "DELETE FROM Juridico WHERE autonum="& autonum &";"
Response.Write "SQL = "& SQL
Response.END
objCon.Execute(sql)

objCon.Close
Set objCon = Nothing
%>

fabio Avila · Julho 24, 2009

Salgado , coloquei da forma q passou e retornou o seguinte resultado :

SQL = DELETE FROM Juridico WHERE autonum=361">Deletar Cadastro;

e agora o que faço?

vlw

Mário Monteiro · Julho 24, 2009

o erro esta no seu formulario

psot o formulario pois ele não esta passando apenas o id e sim isso 361">Deletar Cadastro

deve ta faltando ou sobrando aspas lá

Arquivado

[Resolvido] Erro ao Excluir Registro

Recommended Posts

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mário Monteiro 179

Compartilhar este post

Link para o post

Compartilhar em outros sites

Salgado 4

Compartilhar este post

Link para o post

Compartilhar em outros sites

xanburzum 169

Compartilhar este post

Link para o post

Compartilhar em outros sites

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mário Monteiro 179

Compartilhar este post

Link para o post

Compartilhar em outros sites

xanburzum 169

Compartilhar este post

Link para o post

Compartilhar em outros sites

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

xanburzum 169

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mário Monteiro 179

Compartilhar este post

Link para o post

Compartilhar em outros sites

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mário Monteiro 179

Compartilhar este post

Link para o post

Compartilhar em outros sites

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mário Monteiro 179

Compartilhar este post

Link para o post

Compartilhar em outros sites

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mário Monteiro 179

Compartilhar este post

Link para o post

Compartilhar em outros sites

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Salgado 4

Compartilhar este post

Link para o post

Compartilhar em outros sites

fabio Avila 1

Compartilhar este post

Link para o post

Compartilhar em outros sites

Mário Monteiro 179