[asterisk-users] Asterisk, SQL Database Update

[Bruce Ferrell]

Edwin Quijada wrote:
> 
>> Thanks for your helpful reply.
>>
>>
>>
>> I am not so good in coding.
>>
>>
>>
>> simply all i need is as follow
>>
>>
>>
>> When a call comes, goes into an IVR, and then depending on the entry option
>>
>> it will connect to a remote SQL Database, to check the pre-existed data,
>>
>> and in the end of the IVR the caller will enter an option that will need to be written in the SQL Database.
>>
>>
>>
>> Can you please give me a general scenrio how this will be achieved.
>>
>> and which files that i will need to modify.
>>
> 
> I think that if you are not good coding you will have a few problems.
> Maybe, the best solution 4u is hire external to do that. It is simple 
> but just in dialplan it is so difficult with AGI it is so easy but
> you dont want coding.
>  

depending on what you have in mind the MYSQL command is quite useful.
Have a look at the examples here for some ideas:

http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL

I'm known far and wide as a gonzo hack, but it usually get's the task
accomplished.  :)