Displaying 1 result from an estimated 1 matches for "my_tbl".
Did you mean:
my_dbl
2015 Mar 16
1
Use dialplan variables from MySQL database and replace with value
...How can I do this ?
Currently this is not working. The variable ${PARAMS} contains the exact
string of the database field :
my dialplan :
exten => s,n,MYSQL(Connect connid localhost dbuser dbpass MyTable)
exten => s,n,MYSQL(Query resultid ${connid} SELECT script_url,
script_params FROM my_tbl WHERE ID="${myID}")
exten => s,n,MYSQL(Fetch fetchid ${resultid} scriptURL PARAMS)
exten => s,n,NoOp(scriptURL = ${scriptURL} PARAMS = ${PARAMS})
becomes :
-- Executing [s at sub-details:4] MYSQL("SIP/SipT01-00000012", "Connect
connid localhost dbuser dbpass MyTabl...