lgaetz / freepbx-timelord

FreePBX Module for Asterisk integration with external installation of PHP Timeclock
1 stars 1 forks source link

mysql statements in exten.timeclock.conf don't work #2

Closed lgaetz closed 11 years ago

lgaetz commented 11 years ago

Older versions of Asterisk required escape characters in mysql statements, but they are not permitted in Asterisk 1.8+ this: SELECT \empfullname` FROM `timeclock`.`employees` WHERE `employid` = \'${EMPID}\'`

becomes: SELECTempfullnameFROMtimeclock.employeesWHEREemployid= '${EMPID}'