Displaying 1 result from an estimated 1 matches for "testsql".
Did you mean:
testql
2008 Mar 06
1
AEL - SQL and TIMEDIFF()
...ELECT
DATEDIFF() in my code. The syntax I'm using works without any problems if I
run them directly from the MySQL Client, but from the Asterisk Dialplan it
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...