[asterisk-users] URgent - capturing 'answered'

[Leif Madsen]

On 10-07-26 08:10 AM, Zarko Zivanovic wrote:
> Hello Steve and thanks for your answer,
> However I tried:
>
> $my.query("UPDATE call_log SET local='#{CDR(dstchannel)}', endtime = NOW()
> WHERE id = #{call_log_id}")
>
> And it does write nothing to the database.
>
> I guess there is a error in ruby expression above but I am not sure what is
> wrong - if you have any idea please help.

If that is your literal quote, then I think you need to change the # to a $ as 
Asterisk dialplan functions and variables start with ${ vs #{

Unless that is some special indication in SQL that I'm unfamiliar with.

Leif Madsen.