MYSQL CMD Diaplan with more than one col select

Asterisk Asterisk Support
1

hello,

I tryed to do :

exten => _X.,n,MYSQL(Connect connid ${server_mysql} ${user_mysql} ${mdp_mysql} ${db_mysql})
exten => _X.,n,MYSQL(Query result_conf ${connid} SELECT\ conf\ \action from\ SDA\ where\ SDA=${EXTEN}

how can I use the result of ‘cnf’ and the result of ‘action’ ?

thank you

2

You need to use the “MYSQL fetch”

something like this:

exten => _X.,n,MYSQL(Fetch fetchid ${resultid}  var1 var2)

More on this can be read here:
http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL

Extremely useful stuff for your dialplan.