callaccounging.ws > Asterisk Integration
Connecting to Asterisk using ODBC (recommended)
(1/1)
Administrator:
We now recommend connectivity to Asterisk using our ODBC connectivity method.
The process is fully explained in the new CAM Startup and Installation guide found in our download page:
http://www.callaccounting.ws/download.htm
munozj:
trying to use the ODBC but getting an error when i save the settings
near "?":syntax error
the SQL statement it's trying to use is
select date_add(calldate, interval duration second) as callend, cdr.* from cdr where date_add(calldate, interval duration second)>'?' order by callend asc
i had to load the old 3.51 odbc driver from mysql.com
can't tell what i'm doing wrong in the syntax
Navigation
[0] Message Index
Go to full version