Que erro é esse?...

[interlokk 0]

Olá quando eu executo os script abaixo:

 

<!-- #include file="Config.asp"--><!-- #include file="abrirconexao.asp"--><%'-------------------------------------------------------------'Arquivo: deletar.asp'Descrição: Arquivo utilizado pelo usuário para deletar seu email da lista'Criado dia 14/06/02 - por Flavio Cardoso'http://www.codigolivre.com.br'-------------------------------------------------------------If Request("modo") = "Historico" Thenid = Request.QueryString("id")Response.write "<DIV ALIGN=""center"">" & vbcrlfstrSQL = "DELETE * FROM neurodome.HistoricoLista WHERE id LIKE '" & id & "'"ConnStr.Execute(strSQL)Response.write "<br><br><font size=""2"" face=""arial"">" & Msg_HistoricoDeletadoResponse.write "<br><B><A HREF=""javascript:history.go(-1)"">Voltar</A></B></font>"Response.write "</DIV>" & vbcrlfElseIf Request("modo") = "Email" Thenid = Request.QueryString("id")SerialNumber = Request.QueryString("Serial")Response.write "<DIV ALIGN=""center"">" & vbcrlfstrSQL = "SELECT * FROM neurodome.Newsletter WHERE id LIKE '" & id & "' AND SerialNumber LIKE '" & SerialNumber & "'"set rs= ConnStr.Execute(strSQL)if rs.EOF thenResponse.write "<br><br><font face=""verdana"" size=""2"" color=red>" & Msg_NaoConsta & "</font>"Response.write "<br><B><A HREF=""javascript:history.go(-1)"">Voltar</A></B>"ElsestrSQL = "DELETE * FROM neurodome.Newsletter WHERE id LIKE '" & id & "' AND SerialNumber LIKE '" & SerialNumber & "'"ConnStr.Execute(strSQL)Response.write "<br><br><font face=""verdana"" size=""2"" color=red>" & Msg_EmailDeletadoResponse.write "<br><B><A HREF=""javascript:history.go(-1)"">Voltar</A></B></font>"Response.write "</DIV>" & vbcrlfEnd IfEnd If%><!-- #include file="fecharconexao.asp"-->

aparece a seguinte mensagem de erro:

 

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [MySQL][ODBC 3.51 Driver][mysqld-3.23.58-log]You have an error in your SQL syntax near '* FROM neurodome.Newsletter WHERE id LIKE '13' AND SerialNumber LIKE '446461004'' at line 1 /newsletter/deletar.asp, line 29

Alguem saberia me dizer o que tá acontecendo??? Valeu!

[Salgado 4]

Tira o " *" da sua SQL.

[interlokk 0]

Funcionou! http://forum.imasters.com.br/public/style_emoticons/default/joia.gif Valeu