[asterisk-users] Question about MySQL Fetch foundRow from the dial plan

[Tom Vile]

I have a query that query's my database based on the read input for an ID number.

exten => s,4,MYSQL(Query resultid ${connid} SELECT\ `FirstName`\ `HomePhone`\ FROM\ `contacts`\ WHERE\ `ContactID`= \'${ID}\')
exten => s,5,MYSQL(Fetch foundRow ${resultid} var1 var2) ; fetch row

Problem is is that when I do the following:

exten => s,7,Cepstral(The Phone number for ${var1} is ${var2})

is reads back

Executing Cepstral("SIP/2092-ef65", "The Phone number for John Doe is ") in new stack

The var2 is not displaying.  If I take out FirstName from the query it works fine.

Any suggestions?

--
Tom Vile
6

_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users