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 _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
