Submitted by Corydon76 on Wed, 05/31/2006 - 22:21
One of the new features that will be available in Asterisk 1.4 will be a template-driven SQL function, whose name is func_odbc. This new tool will allow an administrator to create an SQL template, to be filled in with variables from the dialplan. Given popular demand, this module has been backported to 1.2, so it may be used with that earlier version. The svn repository where this backport is kept is at SVN Community. This backport will be kept up to date at least until 1.4 is released.
The simplest case which might show the utility of this new module is a replacement for the DB command:
func_odbc.conf:
[ASTDB]
dsn=mysql1
read=SELECT astvalue FROM astdb WHERE astfamily='${ARG1}' AND astkey='${ARG2}'
write=REPLACE INTO astdb (astfamily, astkey, astvalue) VALUES ('${ARG1}','${ARG2}','${VALUE}')
extensions.conf:
exten => _XXX,1,Set(open=${ODBC_ASTDB(office,open)})
...
; 600 turns the system off, 601 turns the system on
exten => _60[01],1,Set(ODBC_ASTDB(office,open)=${EXTEN:2})
»
- Corydon76's blog
- Login or register to post comments
It brings together more than
It brings together more than a decade of Cisco innovation in multiple security and networking disciplines, making use of all the technology from Cisco PIX Security Appliances, Cisco VPN 3000 Security Appliances, Cisco IPS 4200 Series Appliances, and many Cisco IP networking innovations. In addition, Cisco today announced collaboration with industry leaders on the Unified Computing System and architecture. Though the company is still holding back details, it has not disputed speculation that points to a kind of “blade” server, the compact back-office machines that power corporate data centers. The Cisco announcement doesn't really make me excited – don't get me wrong; Cisco systems putting out a router that handles 3 times the traffic is AWESOME, and it would be worth maybe a small payday loans worth to get one, but this isn't exactly huge news for a technology company. The power of the biggest processor chip doubles every year or two, right? That's the power of the private sector. The router in question is going to be obsolete within a few years after it comes out anyway. I'll buy one when the cost goes down.
Prom Dresses 2010 including
Prom Dresses 2010 including designer Jovani prom dresses, cheap and affordable prom dresses,
sexy prom dress, wedding, bridesmaid and mother of the bride
Wedding Gowns
Evening Gowns
Formal Gowns
Prom Gowns
Shop prom dresses, formal dresses, prom shoes, 2010 designer prom gowns at dres4sale.
for cocktail dresses, dresses for prom, homecoming dresses, and evening dresses. Cheap prom dresses or couture designer evening gowns for your next formal.
evening dresses
Wedding Gowns
Evening Gowns