Displaying 1 result from an estimated 1 matches for "tblcall".
Did you mean:
tailcall
2008 Mar 06
1
AEL - SQL and TIMEDIFF()
...just wont work. Is there a limitation in the MySQL() application for the
Asterisk dialplan that produces this error?
<CODE>
context testsql {
s => {
MYSQL(Connect connid ${DBHOST} ${DBUSER} ${DBPASS} ${DB});
MYSQL(Query resultid ${connid} SELECT TIMEDIFF(callend,callstart) FROM
tblCall WHERE id=7);
MYSQL(fetch fetchid ${resultid} temp);
MYSQL(Disconnect ${connid});
}
}
</CODE>
The error I'm getting is below:
[Mar 6 08:59:35] WARNING[27116]: app_addon_sql_mysql.c:268 aMYSQL_query:
aMYSQL_query: mysql_query failed. Error: You have an error in your SQL
syntax;...