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