<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1555" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=943493713-19072006><FONT face=Arial
color=#0000ff size=2>Não...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=943493713-19072006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=943493713-19072006><FONT face=Arial
color=#0000ff size=2>O problema era de sintaxe.. estavam faltando algumas aspas
' na query!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=943493713-19072006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=943493713-19072006><FONT face=Arial
color=#0000ff size=2>Valeu!<BR>Dov</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
asteriskbrasil-bounces@listas.asteriskbrasil.org
[mailto:asteriskbrasil-bounces@listas.asteriskbrasil.org] <B>On Behalf Of
</B>Rodrigo Sertori<BR><B>Sent:</B> quarta-feira, 19 de julho de 2006
08:35<BR><B>To:</B> asteriskbrasil@listas.asteriskbrasil.org<BR><B>Subject:</B>
Re: [AsteriskBrasil] comando MySQL<BR></FONT><BR></DIV>
<DIV></DIV>Opa.. nao sei se tem algo haver but.... normalmente vc deve mandar
aspas com campos textos...<BR>da uma testada ae!!!<BR><BR><FONT size=2><FONT
color=#000000>exten => 8892,n,NoOp(A variavel aaaa eh:
${aaaa})</FONT></FONT><FONT size=2> <--- 'aaaa' ou
"aaaa"</FONT><BR><BR><BR>=]<BR><BR><BR>Em Ter, 2006-07-18 às 17:12 -0300, Dov
Bigio escreveu:
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>Caros,</FONT></FONT>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT color=#000000></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>Alguem já usou a
aplicação MySQL do Asterisk add ons?</FONT></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT color=#000000></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>Estou fazendo testes
com ela, e meus SELECTs funcionam, mas INSERTs e UPDATES não...</FONT></FONT>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>(Não é problema de
permissão no banco, pq estou conectando como administrador)</FONT></FONT>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT color=#000000></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>exten =>
8892,1,MySQL(Connect connid SERVIDOR root SENHA
BASE)</FONT></FONT><BR><FONT size=2><FONT color=#000000>exten =>
8892,n,MySQL(Query resultid ${connid} insert\ into\ mysql_asterisk\
(callerid\,passo\,info)\
values(${CALLERIDNUM}\,1\,aaa))</FONT></FONT><BR><FONT size=2><FONT
color=#000000>exten => 8892,n,MySQL(Disconnect
${connid})</FONT></FONT><BR><FONT size=2><FONT color=#000000>exten =>
8892,n,Hangup</FONT></FONT><BR><BR></BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>Ele passa por todos
etapas, sem mensagem de erro, mas nao insere no banco...
</FONT></FONT></BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT color=#000000></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>Com o SELECT
(abaixo), funciona direitinho!!</FONT></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT color=#000000></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>exten =>
8892,1,MySQL(Connect connid SERVIDOR root SENHA BASE)</FONT></FONT>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT color=#000000>exten =>
8892,n,MySQL(Query resultid ${connid} select\ callerid\ from\
mysql_asterisk)</FONT></FONT><BR><FONT size=2><FONT color=#000000>exten =>
8892,n,MySQL(Fetch fetchid ${resultid} aaaa)</FONT></FONT><BR><FONT
size=2><FONT color=#000000>exten => 8892,n,MySQL(Clear
${resultid})</FONT></FONT><BR><FONT size=2><FONT color=#000000>exten =>
8892,n,NoOp(A variavel aaaa eh: ${aaaa})</FONT></FONT><BR><FONT size=2><FONT
color=#000000>exten => 8892,n,MySQL(Disconnect
${connid})</FONT></FONT><BR><FONT size=2><FONT color=#000000>exten =>
8892,n,Hangup</FONT></FONT><BR><BR></BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><FONT size=2><FONT
color=#000000>[]s</FONT></FONT><BR><FONT size=2><FONT
color=#000000>Dov</FONT></FONT> </BLOCKQUOTE>
<BLOCKQUOTE TYPE="CITE"><PRE><FONT color=#000000>_______________________________________________</FONT>
<FONT color=#000000>LIsta de discussões AsteriskBrasil.org</FONT>
<FONT color=#000000><A href="mailto:AsteriskBrasil@listas.asteriskbrasil.org">AsteriskBrasil@listas.asteriskbrasil.org</A></FONT>
<FONT color=#000000><A href="http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil">http://listas.asteriskbrasil.org/mailman/listinfo/asteriskbrasil</A></FONT>
<FONT color=#000000>_______________________________________________</FONT>
<FONT color=#000000>Acesse o wiki AsteriskBrasil.org:</FONT>
<FONT color=#000000><A href="http://www.asteriskbrasil.org">http://www.asteriskbrasil.org</A></FONT>
</PRE></BLOCKQUOTE>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD><BR>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD><PRE><FONT color=#ff0000> .''`.</FONT> <B><FONT color=#000080>Rodrigo Sertori</FONT></B>
<FONT color=#ff0000>: :' :</FONT> <B><FONT size=1>Analista de Sistemas</FONT></B>
<FONT color=#ff0000>`. `'`</FONT> <FONT size=1>+55 16 9151 1392</FONT>
<FONT color=#ff0000>`-</FONT>
<IMG src="cid:943493713@19072006-072B" align=bottom border=0>
</PRE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></BODY></HTML>