<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
if you are using MYSQL.. why don't you query your DB directly from Asterisk ?<BR>
the following example is something i use with my servers<BR>
<BR>
[ivr1-cont]<BR>exten => 7700,1,Answer<BR>
exten => 7700,n,MYSQL(Connect connid 127.0.0.1 root rootpass TarekDB)<BR>exten => 7700,n,MYSQL(Query resultid_2 ${connid} SELECT q_name FROM tbl_ivr ORDER BY RAND( ) LIMIT 1 )<BR>exten => 7700,n,MYSQL(Fetch fetchid1 ${resultid_2} question)<BR>exten => 7700,n,Read(A1,ivr1/${question})<BR>exten => 7700,n,MYSQL(Disconnect ${connid})<BR>
<BR>
<BR><BR>-- AHD Tarek Sawah Integrated Digital Systems CCNA, MCSE, RHCE, VoIP Syria: +963 944 618286 USA: +1 347 562 2308 <BR><BR><BR><BR><BR>
<HR id=stopSpelling>
<BR>
From: scgm@adinet.com.uy<BR>To: asterisk-users@lists.digium.com<BR>Date: Tue, 9 Dec 2008 15:45:59 -0200<BR>Subject: [asterisk-users] Func_ODBC question<BR><BR><BR>
<STYLE>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p.EC_MsoAcetate, .ExternalClass li.EC_MsoAcetate, .ExternalClass div.EC_MsoAcetate
{margin-bottom:.0001pt;font-size:8.0pt;font-family:'Tahoma','sans-serif';}
.ExternalClass span.EC_EmailStyle17
{font-family:'Calibri','sans-serif';color:windowtext;}
.ExternalClass span.EC_BalloonTextChar
{font-family:'Tahoma','sans-serif';}
.ExternalClass .EC_MsoChpDefault
{;}
@page Section1
{size:612.0pt 792.0pt;}
.ExternalClass div.EC_Section1
{page:Section1;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoNormal><SPAN lang=EN-US>Hi I have</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>On func_odbc</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>[EXEC]</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>readhandle=ressqlserver</SPAN></P>
<P class=EC_MsoNormal>writehandle=ressqlserver</P>
<P class=EC_MsoNormal>readsql=${ARG1}</P>
<P class=EC_MsoNormal>writesql=${ARG1}</P>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal><SPAN lang=EN-US>I’m trying an update on dialplan:</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>exten=> 141,3,Set(dummy=${ODBC_EXEC(UPDATE Tabla set campo = ${EXTEN})})</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>On Cli:</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>WARNING[3579]: func_odbc.c:353 acf_odbc_read: Error -1 in FETCH [UPDATE Tabla set campo = 4356]</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>Any idea why is this??</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>The query works fine, I just wanto to know if the warning can cause any problem to me.</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>Thanks!!</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US>Sebastian</SPAN></P>
<P class=EC_MsoNormal><SPAN lang=EN-US> </SPAN></P></DIV><BR><BR>__________ Information from ESET Smart Security, version of virus signature database 3677 (20081209) __________<BR><BR>The message was checked by ESET Smart Security.<BR><BR><A>http://www.eset.com</A><BR><br /><hr />Send e-mail faster without improving your typing skills. <a href='http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008' target='_new'>Get your Hotmail® account.</a></body>
</html>