Syntax error (missing operator)

Vinicius Santanna · Março 18, 2007

Ae galera beleza!?Vamos direto ao ponto: Tenho esse codigo:

<%Option ExplicitResponse.Expires = 0Dim objConn, strQuery, sql_query, RsQuery, v_consultor, v_ano, v_mes, v_dia, v_info, id, V_empresaDim  ObjRsv_consultor = Request.Form("consultor")v_ano = Request.Form("ano")v_mes = Request.Form("mes")v_dia = Request.Form("dia")v_empresa = Request.Form("empresa")v_info = Request.Form("info")if v_info = "" then	v_Info = "Não Definido"end ifid = Request.Form("ID")Set objConn =  Server.CreateObject("ADODB.Connection")objConn.Open "DBQ=" & Server.MapPath("santanna_agenda.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}","username","password"strQuery = "UPDATE agenda SET DB_Consultor= '"&v_consultor&"', DB_Dia = '"&v_dia&"', DB_Mes ='"&v_Mes&"', DB_Ano ='"&v_Ano&"', DB_Info ='"&v_Info&"' WHERE ID = "&id&" "On error Resume NextSet ObjRs = objConn.Execute(strQuery)objConn.closeSet objRs = NothingSet objConn = Nothing If Err ThenResponse.Write (Err.Description)else Response.Redirect("agenda_inicial.asp")end If%>

Só que esse codigo infeliz tá dando esse erro : [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID='.;

OBS: esse ID é um botão "radio"

Já tentei de outras maneiras mas nenhuma da certo!, Oq pode ser?

Grato

Vinicius Sant'Anna

Mário Monteiro · Março 18, 2007

aparentemente nao esta passando corretamente o valor do IDescreve na tela a sua SQl para vermos o que esta realmente acontecendo

Vinicius Santanna · Março 19, 2007

Esta é a pagina que o usuario escolhe a entrada que ira alterar :

<!--#include virtual="/novo/restrito/autoriza/autoriza_nivel2.asp" --><%Response.Expires = 0Dim objConn, objRs, strQuery, strConnection, v_dia, V_mes, v_ano, v_Consultor Set objConn =  Server.CreateObject("ADODB.Connection")objConn.Open "DBQ=" & Server.MapPath("santanna_agenda.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}", "username", "password"v_Consultor = Request.cookies("autenticacao")("anome") v_Dia = Request.Form("vPg_dia")v_Mes = Request.Form("vPg_Mes")v_Ano = Request.Form("vPg_Ano")'--------------------------------------------'If v_Consultor = "Anselmo" thenstrQuery = " SELECT distinct ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where DB_Dia = '"&v_Dia&"' and DB_Mes = '"&v_Mes&"' and  DB_Ano = '"&v_Ano&"'"elsestrQuery = " SELECT distinct ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where DB_Dia = '"&v_Dia&"' and DB_Mes = '"&v_Mes&"' and  DB_Ano = '"&v_Ano&"' and DB_Consultor = '"&v_consultor&"' "end if  '----------------------------------------------'On error Resume NextSet ObjRs = objConn.Execute(strQuery)If Err ThenResponse.Write (Err.Description)end If%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Santannaconsultoria.com.br - Agenda - Seja bem-vindo</title><style type="text/css">@import url(../padrao.css);a {	font-size: 12px;	color: #FF9900;}a:link {	text-decoration: none;}a:visited {	text-decoration: none;	color: #999999;}a:hover {	text-decoration: none;	color: #FFCC00;}a:active {	text-decoration: none;	color: #FF9900;}body,td,th {	font-size: 10pt;}.style3 {	color: #FF6600;	font-weight: bold;}.style4 {	color: #FFFFFF;	font-weight: bold;}.style6 {color: #000000}</style></head><body topmargin="0" leftmargin="0"><div align="center">  <table width="779" border="0" cellspacing="0" cellpadding="0" align="center">	<tr>	  <td><img src="../../Imagens_chaves/topo_completo.jpg" width="779" height="164" /></td>	</tr>	<tr>	  <td><img src="../../Imagens_chaves/Menu_agenda.jpg" width="779" height="22" border="0" usemap="#Map" />		<map name="Map" id="Map">		  <area shape="rect" coords="240,3,285,18" href="../Home/Index.html" />		  <area shape="rect" coords="61,2,222,18" href="pg_consultores.asp" />		<area shape="rect" coords="2,3,50,18" href="agenda_inicial.asp" />		</map>	  </td>	</tr>	<tr>	  <td height="57" align="left" bgcolor="#F9F9F9"><form id="form1" name="form1" method="post" action="form_altera.asp">		<table width="100%" border="0" cellspacing="0" cellpadding="0">		  <tr>			<td> </td>		  </tr>		  <tr>			<td height="27" align="right" valign="middle" bgcolor="#FF9900"><input name="Alterar" type="submit" id="Alterar" value="Alterar" /></td>		  </tr>		  <tr>			<td height="143" valign="top"><%While Not objRS.EOF%>			  <br />			  <table width="778" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" >			  <tr>				<td width="71" align="right" bgcolor="#000000"><span class="style4">Entrada N°: </span></td>				<td width="62" bgcolor="#CCCCCC"><span class="style3"><font size="1">				  <font face="Verdana, Arial, Helvetica, sans-serif">				  <%Response.write objRS("ID")%>					</font></font></span></td>				<td width="41" align="right" bgcolor="#000000"><span class="style4">Data:</span></td>				<td width="594" bgcolor="#CCCCCC"> <%Response.write objRS("DB_Dia")%>/  <%Response.write objRS("DB_mes")%>/<%Response.write objRS("DB_ano")%></td>				</tr>			  <tr>				<td align="right" bgcolor="#000000"><span class="style4">Consultor: </span></td>				<td colspan="3" bgcolor="#CCCCCC"><%Response.write objRS("DB_Consultor")%></td>				</tr>			  <tr>				<td align="right" bgcolor="#000000"><span class="style4">Empresa:</span></td>				<td colspan="3" bgcolor="#CCCCCC"><%Response.write objRS("DB_empresa1")%></td>				</tr>			  <tr>				<td align="right" valign="top" bgcolor="#000000"><span class="style4">Atividades : </span></td>				<td colspan="3" bgcolor="#CCCCCC"><%Response.write objRS("DB_info")%></td>			  </tr>			  <tr>				<td colspan="4" align="right" valign="top" bgcolor="#CCCCCC"><font size="1"><b>				  <font face="Verdana, Arial, Helvetica, sans-serif"><span class="style6">selecionar para alteração				  </span>				  </font><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">				  <input type="radio" name="radio" value="<%=objRS(0)%>" /> 				  </font></b></font></td>				</tr>			</table>			  <%  objRS.MoveNext  Wend  objRs.close  objConn.close  Set objRs = Nothing  Set objConn = Nothing  %></td>		  </tr>		</table>		<label></label>	  </form>	  </td>	</tr>	<tr>	  <td> </td>	</tr>  </table></div></body></html>

E Esta é a pagina em que o usuario ira alterar as informações :

<!--#include virtual="/novo/restrito/autoriza/autoriza_nivel2.asp" --><%Response.Expires = 0Dim objConn, objRs, strQuery, strConnection, idSet objConn =  Server.CreateObject("ADODB.Connection")objConn.Open "DBQ=" & Server.MapPath("santanna_agenda.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}", "username", "password"id = Request.QueryString("radio")strQuery = " SELECT ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where ID= "&id&""On error Resume NextSet ObjRs = objConn.Execute(strQuery)If Err ThenResponse.Write (Err.Description)end If%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Santannaconsultoria.com.br - Agenda - Seja bem-vindo</title><style type="text/css">@import url(../padrao.css);a {	font-size: 12px;	color: #FF9900;}a:link {	text-decoration: none;}a:visited {	text-decoration: none;	color: #999999;}a:hover {	text-decoration: none;	color: #FFCC00;}a:active {	text-decoration: none;	color: #FF9900;}body,td,th {	font-size: 10pt;}.style3 {	color: #FF6600;	font-weight: bold;}.style4 {	color: #FFFFFF;	font-weight: bold;}.style6 {color: #000000}</style></head><body topmargin="0" leftmargin="0"><div align="center">  <table width="779" border="0" cellspacing="0" cellpadding="0" align="center">	<tr>	  <td><img src="../../Imagens_chaves/topo_completo.jpg" width="779" height="164" /></td>	</tr>	<tr>	  <td><img src="../../Imagens_chaves/Menu_agenda.jpg" width="779" height="22" border="0" usemap="#Map" />		<map name="Map" id="Map">		  <area shape="rect" coords="240,3,285,18" href="../Home/Index.html" />		  <area shape="rect" coords="61,2,222,18" href="pg_consultores.asp" />		<area shape="rect" coords="2,3,50,18" href="agenda_inicial.asp" />		</map>	  </td>	</tr>	<tr>	  <td height="57" align="left" bgcolor="#F9F9F9"><form id="form1" name="form1" method="get" action="altera_dados.asp">		<table width="100%" border="0" cellspacing="0" cellpadding="0">		  <tr>			<td> </td>		  </tr>		  <tr>			<td height="28" align="right" valign="middle" bgcolor="#FF9900"><input name="Alterar" type="submit" id="Alterar" value="Confirmar Alteração" /></td>		  </tr>		  <tr>			<td height="143" valign="top"><table width="778" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" >				<tr>				  <td width="71" height="28" align="right" bgcolor="#000000"><span class="style4">Entrada N°: </span></td>				  <td width="62" bgcolor="#CCCCCC"><span class="style3"><font size="1">					<font face="Verdana, Arial, Helvetica, sans-serif">					  <%Response.write objRS("ID")%>					  </font></font></span></td>				  <td width="41" align="right" bgcolor="#000000"><span class="style4">Data:</span></td>				  <td width="594" height="30" bgcolor="#CCCCCC"> 					<input name="dia" type="text" id="dia" value="<%=objRS("DB_Info")%>" size="3" maxlength="2" />										/					<input name="mes" type="text" id="mes" value="<%=objRS("DB_mes")%>" size="3" maxlength="2" />										/					<input name="ano" type="text" id="ano" value="<%=objRS("DB_ano")%>" size="5" maxlength="4" /></td>				</tr>				<tr>				  <td height="28" align="right" bgcolor="#000000"><span class="style4">Consultor: </span></td>				  <td height="30" colspan="3" bgcolor="#CCCCCC"><input name="consultor" type="text" id="consultor" value="<%=objRS("DB_Consultor")%>" size="35" /></td>				</tr>				<tr>				  <td align="right" bgcolor="#000000"><span class="style4">Empresa:</span></td>				  <td height="30" colspan="3" bgcolor="#CCCCCC"><input name="empresa" type="text" id="empresa" value="<%=objRS("DB_Empresa1")%>" size="35" /></td>				</tr>				<tr>				  <td align="right" valign="top" bgcolor="#000000"><span class="style4">Atividades : </span></td>				  <td height="80" colspan="3" bgcolor="#CCCCCC"><textarea name="info" cols="32" rows="4" id="info"><%=objRS("DB_dia")%></textarea>					<input name="ID" type="hidden" id="ID" value="<%=objRS("ID")%>" /></td>				</tr>				<tr>				  <td colspan="4" align="right" valign="top" bgcolor="#CCCCCC"> </td>				  </tr>				</table>			  </td></tr>		</table>		<label></label>	  </form>	  </td>	</tr>	<tr>	  <td> </td>	</tr>  </table></div></body></html>

O Erro está dando quando o se abre a pagina para alterar.

A Query dessa pagina é esta: strQuery = " SELECT ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where ID= "&id&""

e o erro é este : Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID='.

Se não for erro de programação acho que pode ter haver com o tipo de campo do Accees, que é auto numerico..só sei que isso tá me dando um p* dor de cabeça!

Grato

Vinicius Sant'Anna

jothaz · Março 19, 2007

Esta é a pagina que o usuario escolhe a entrada que ira alterar :

<!--#include virtual="/novo/restrito/autoriza/autoriza_nivel2.asp" --><%Response.Expires = 0Dim objConn, objRs, strQuery, strConnection, v_dia, V_mes, v_ano, v_Consultor Set objConn =  Server.CreateObject("ADODB.Connection")objConn.Open "DBQ=" & Server.MapPath("santanna_agenda.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}", "username", "password"v_Consultor = Request.cookies("autenticacao")("anome") v_Dia = Request.Form("vPg_dia")v_Mes = Request.Form("vPg_Mes")v_Ano = Request.Form("vPg_Ano")'--------------------------------------------'If v_Consultor = "Anselmo" thenstrQuery = " SELECT distinct ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where DB_Dia = '"&v_Dia&"' and DB_Mes = '"&v_Mes&"' and  DB_Ano = '"&v_Ano&"'"elsestrQuery = " SELECT distinct ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where DB_Dia = '"&v_Dia&"' and DB_Mes = '"&v_Mes&"' and  DB_Ano = '"&v_Ano&"' and DB_Consultor = '"&v_consultor&"' "end if  '----------------------------------------------'On error Resume NextSet ObjRs = objConn.Execute(strQuery)If Err ThenResponse.Write (Err.Description)end If%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Santannaconsultoria.com.br - Agenda - Seja bem-vindo</title><style type="text/css">@import url(../padrao.css);a {	font-size: 12px;	color: #FF9900;}a:link {	text-decoration: none;}a:visited {	text-decoration: none;	color: #999999;}a:hover {	text-decoration: none;	color: #FFCC00;}a:active {	text-decoration: none;	color: #FF9900;}body,td,th {	font-size: 10pt;}.style3 {	color: #FF6600;	font-weight: bold;}.style4 {	color: #FFFFFF;	font-weight: bold;}.style6 {color: #000000}</style></head><body topmargin="0" leftmargin="0"><div align="center">  <table width="779" border="0" cellspacing="0" cellpadding="0" align="center">	<tr>	  <td><img src="../../Imagens_chaves/topo_completo.jpg" width="779" height="164" /></td>	</tr>	<tr>	  <td><img src="../../Imagens_chaves/Menu_agenda.jpg" width="779" height="22" border="0" usemap="#Map" />		<map name="Map" id="Map">		  <area shape="rect" coords="240,3,285,18" href="../Home/Index.html" />		  <area shape="rect" coords="61,2,222,18" href="pg_consultores.asp" />		<area shape="rect" coords="2,3,50,18" href="agenda_inicial.asp" />		</map>	  </td>	</tr>	<tr>	  <td height="57" align="left" bgcolor="#F9F9F9"><form id="form1" name="form1" method="post" action="form_altera.asp">		<table width="100%" border="0" cellspacing="0" cellpadding="0">		  <tr>			<td> </td>		  </tr>		  <tr>			<td height="27" align="right" valign="middle" bgcolor="#FF9900"><input name="Alterar" type="submit" id="Alterar" value="Alterar" /></td>		  </tr>		  <tr>			<td height="143" valign="top"><%While Not objRS.EOF%>			  <br />			  <table width="778" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" >			  <tr>				<td width="71" align="right" bgcolor="#000000"><span class="style4">Entrada N°: </span></td>				<td width="62" bgcolor="#CCCCCC"><span class="style3"><font size="1">				  <font face="Verdana, Arial, Helvetica, sans-serif">				  <%Response.write objRS("ID")%>					</font></font></span></td>				<td width="41" align="right" bgcolor="#000000"><span class="style4">Data:</span></td>				<td width="594" bgcolor="#CCCCCC"> <%Response.write objRS("DB_Dia")%>/  <%Response.write objRS("DB_mes")%>/<%Response.write objRS("DB_ano")%></td>				</tr>			  <tr>				<td align="right" bgcolor="#000000"><span class="style4">Consultor: </span></td>				<td colspan="3" bgcolor="#CCCCCC"><%Response.write objRS("DB_Consultor")%></td>				</tr>			  <tr>				<td align="right" bgcolor="#000000"><span class="style4">Empresa:</span></td>				<td colspan="3" bgcolor="#CCCCCC"><%Response.write objRS("DB_empresa1")%></td>				</tr>			  <tr>				<td align="right" valign="top" bgcolor="#000000"><span class="style4">Atividades : </span></td>				<td colspan="3" bgcolor="#CCCCCC"><%Response.write objRS("DB_info")%></td>			  </tr>			  <tr>				<td colspan="4" align="right" valign="top" bgcolor="#CCCCCC"><font size="1"><b>				  <font face="Verdana, Arial, Helvetica, sans-serif"><span class="style6">selecionar para alteração				  </span>				  </font><font face="Verdana, Arial, Helvetica, sans-serif" color="#000000">				  <input type="radio" name="radio" value="<%=objRS(0)%>" /> 				  </font></b></font></td>				</tr>			</table>			  <%  objRS.MoveNext  Wend  objRs.close  objConn.close  Set objRs = Nothing  Set objConn = Nothing  %></td>		  </tr>		</table>		<label></label>	  </form>	  </td>	</tr>	<tr>	  <td> </td>	</tr>  </table></div></body></html>

E Esta é a pagina em que o usuario ira alterar as informações :

<!--#include virtual="/novo/restrito/autoriza/autoriza_nivel2.asp" --><%Response.Expires = 0Dim objConn, objRs, strQuery, strConnection, idSet objConn =  Server.CreateObject("ADODB.Connection")objConn.Open "DBQ=" & Server.MapPath("santanna_agenda.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}", "username", "password"id = Request.QueryString("radio")strQuery = " SELECT ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where ID= "&id&""On error Resume NextSet ObjRs = objConn.Execute(strQuery)If Err ThenResponse.Write (Err.Description)end If%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Santannaconsultoria.com.br - Agenda - Seja bem-vindo</title><style type="text/css">@import url(../padrao.css);a {	font-size: 12px;	color: #FF9900;}a:link {	text-decoration: none;}a:visited {	text-decoration: none;	color: #999999;}a:hover {	text-decoration: none;	color: #FFCC00;}a:active {	text-decoration: none;	color: #FF9900;}body,td,th {	font-size: 10pt;}.style3 {	color: #FF6600;	font-weight: bold;}.style4 {	color: #FFFFFF;	font-weight: bold;}.style6 {color: #000000}</style></head><body topmargin="0" leftmargin="0"><div align="center">  <table width="779" border="0" cellspacing="0" cellpadding="0" align="center">	<tr>	  <td><img src="../../Imagens_chaves/topo_completo.jpg" width="779" height="164" /></td>	</tr>	<tr>	  <td><img src="../../Imagens_chaves/Menu_agenda.jpg" width="779" height="22" border="0" usemap="#Map" />		<map name="Map" id="Map">		  <area shape="rect" coords="240,3,285,18" href="../Home/Index.html" />		  <area shape="rect" coords="61,2,222,18" href="pg_consultores.asp" />		<area shape="rect" coords="2,3,50,18" href="agenda_inicial.asp" />		</map>	  </td>	</tr>	<tr>	  <td height="57" align="left" bgcolor="#F9F9F9"><form id="form1" name="form1" method="get" action="altera_dados.asp">		<table width="100%" border="0" cellspacing="0" cellpadding="0">		  <tr>			<td> </td>		  </tr>		  <tr>			<td height="28" align="right" valign="middle" bgcolor="#FF9900"><input name="Alterar" type="submit" id="Alterar" value="Confirmar Alteração" /></td>		  </tr>		  <tr>			<td height="143" valign="top"><table width="778" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" >				<tr>				  <td width="71" height="28" align="right" bgcolor="#000000"><span class="style4">Entrada N°: </span></td>				  <td width="62" bgcolor="#CCCCCC"><span class="style3"><font size="1">					<font face="Verdana, Arial, Helvetica, sans-serif">					  <%Response.write objRS("ID")%>					  </font></font></span></td>				  <td width="41" align="right" bgcolor="#000000"><span class="style4">Data:</span></td>				  <td width="594" height="30" bgcolor="#CCCCCC"> 					<input name="dia" type="text" id="dia" value="<%=objRS("DB_Info")%>" size="3" maxlength="2" />										/					<input name="mes" type="text" id="mes" value="<%=objRS("DB_mes")%>" size="3" maxlength="2" />										/					<input name="ano" type="text" id="ano" value="<%=objRS("DB_ano")%>" size="5" maxlength="4" /></td>				</tr>				<tr>				  <td height="28" align="right" bgcolor="#000000"><span class="style4">Consultor: </span></td>				  <td height="30" colspan="3" bgcolor="#CCCCCC"><input name="consultor" type="text" id="consultor" value="<%=objRS("DB_Consultor")%>" size="35" /></td>				</tr>				<tr>				  <td align="right" bgcolor="#000000"><span class="style4">Empresa:</span></td>				  <td height="30" colspan="3" bgcolor="#CCCCCC"><input name="empresa" type="text" id="empresa" value="<%=objRS("DB_Empresa1")%>" size="35" /></td>				</tr>				<tr>				  <td align="right" valign="top" bgcolor="#000000"><span class="style4">Atividades : </span></td>				  <td height="80" colspan="3" bgcolor="#CCCCCC"><textarea name="info" cols="32" rows="4" id="info"><%=objRS("DB_dia")%></textarea>					<input name="ID" type="hidden" id="ID" value="<%=objRS("ID")%>" /></td>				</tr>				<tr>				  <td colspan="4" align="right" valign="top" bgcolor="#CCCCCC"> </td>				  </tr>				</table>			  </td></tr>		</table>		<label></label>	  </form>	  </td>	</tr>	<tr>	  <td> </td>	</tr>  </table></div></body></html>

O Erro está dando quando o se abre a pagina para alterar.

A Query dessa pagina é esta: strQuery = " SELECT ID,DB_Dia,DB_Mes,DB_Ano,DB_empresa1,DB_info,DB_Consultor FROM Agenda where ID= "&id&""

e o erro é este : Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID='.

Se não for erro de programação acho que pode ter haver com o tipo de campo do Accees, que é auto numerico..só sei que isso tá me dando um p* dor de cabeça!

Grato

Vinicius Sant'Anna

Camarada,

Acho que o erro tá bem clado>

e o erro é este : Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID='.

Pelo que me parece e o marioufpa tinha notado o seu campo ID esta nulo.

Execute o comando:

response.write "|" & id & "|"

E post5 o resultado aqui.

t+

Mário Monteiro · Março 21, 2007

correto precisa ver se os parametros que esta passando para a query estao todos corretos pois ao que parece o ID nao está

Vinicius Santanna · Março 22, 2007

Valew pessoal consegui!...o erro tava no request.form!!!!.....eheh bem simples não?!

Entrar

Arquivado

Syntax error (missing operator)

Recommended Posts

Vinicius Santanna 0

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

Vinicius Santanna 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

jothaz 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

Vinicius Santanna 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

Fixar div até atingir uma certa altura

Ajuda com Extends e envio para o banco

PHP+Codeginiter - Orientação para Impressão

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante