<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.10.2">
</HEAD>
<BODY>
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%">
<TR>
<TD>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<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:1153308879.13467.3.camel@littleangel.convex.com.br" ALIGN="bottom" BORDER="0">
</PRE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>