Displaying 1 result from an estimated 1 matches for "devtype_id".
2009 Apr 22
1
Upgrading from 1.4.21.2 to 1.6.0.5 breaks sql queries with backslashes?
...pbx WHERE mailbox="${CALLERID(num)}" and vpbx_id=vpbx.id)
exten => s,3,MYSQL(Fetch fetchid ${resultid} vpbx-id vpbx-password vpbx)
exten => s,4,MYSQL(Clear ${resultid})
exten => s,5,MYSQL(Query resultid ${connid} SELECT mailbox FROM ext\,devtype WHERE active="Y" and ext.devtype_id=devtype.id and devtype.model like "AUTOATTENDANT%" and vpbx_id=${vpbx-id})
exten => s,6,MYSQL(Fetch fetchid ${resultid} mailbox)
exten => s,7,MYSQL(Clear ${resultid})
exten => s,8,Set(vpbx-number=${mailbox})
exten => s,9,MYSQL(Disconnect ${connid})
exten => s,10,Return
And...