search for: dbpw

Hi Most of our customers have generic names like "Hospital", so I need to rewrite their caller ID name by looking up the number in a database on the Asterisk server, and rewriting the name such as "Reading Hospital" so that we know who's calling. Any idea if this can be done with Asterisk, and how to do it? Thank you.

...ed asterisk to have already used them to escape the commas, but I could be wrong. Here's an example of a failing query from extensions.conf (line 2) that works fine in 1.4.21.2 and fails in 1.6.0.5: [vpbx-generic-cc-get-vpbx-number] exten => s,1,MYSQL(Connect connid ${DBHOST} ${DBUSER} ${DBPW} ${DBNAME}) exten => s,2,MYSQL(Query resultid ${connid} SELECT vpbx_id\,vpbx.password\,vpbx.name FROMext\,vpbx 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}) exte...