[asterisk-users] database queries from extensions.conf

[Al Baker]

Klaus Darilion wrote:
> Hi Jared!
>
> Thanks for the info - looks very flexible - you only have to edit 4 
> configuration files for a simple query :-)
>
> just a few questions:
> The ODBC library is unixodbc?
>
> How does it compare to the other solutions in terms of performance? e.g. 
> (I have to make several queries for each call (caller preferences, LNP, 
> LCR...)
>
> regards
> klaus
>
> Jared Smith schrieb:
>   
>> On Thu, 2008-11-13 at 15:16 +0100, Klaus Darilion wrote:
>>     
>>> What is the preferred way to make database lookups from within the dialplan?
>>>       
>> The preferred method is to use func_odbc, which takes SQL queries and
>> builds custom dialplan functions from them.  I've used it quite a bit,
>> and am very happy with it.
>>
>> I also presented on func_odbc at AstriCon, and you can download my
>> presentation:
>>
>> http://www.astricon.net/2008/glendale/web/presentations/DatabaseDriven_JSmith.pdf
>>
>>
>>
>>     
>   

Quote "
The preferred method is to use func_odbc, which takes SQL queries and 
builds custom dialplan functions from them. I've used it quite a bit,

and am very happy with it."

How can you be VERY HappY with  something that allows ONLY single statemts of SQL, ipso-facto you CANNOT
do
Begin Transaction
SQL Statement
SQL Statement
End Transaction

This isSOOO much more limited that the MYSQl add-on