I have a query that query's my database based on the read input for an ID number.<br><br>exten => s,4,MYSQL(Query resultid ${connid} SELECT\ `FirstName`\ `HomePhone`\ FROM\ `contacts`\ WHERE\ `ContactID`= \'${ID}\')<br>
exten => s,5,MYSQL(Fetch foundRow ${resultid} var1 var2) ; fetch row<br><br>Problem is is that when I do the following:<br><br>exten => s,7,Cepstral(The Phone number for ${var1} is ${var2})<br><br>is reads back<br><br>
Executing Cepstral("SIP/2092-ef65", "The Phone number for John Doe is ") in new stack<br><br>The var2 is not displaying. If I take out FirstName from the query it works fine.<br><br>Any suggestions?<br clear="all">
<br>-- <br>Tom Vile<br>6