asterisk users - Nov 2006 - Question about MySQL Fetch foundRow from the dial plan

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20061113/97c958f4/attachment.htm