asterisk users - Oct 2010 - MS-SQL / Freetds -- func_odbc

Hi folks, 

How would I go about running a stored procedure call from asterisk via
func_odbc. 

I'm after an example entry in func_odbc if possible for ast 1.4

Also, if someone could post an insert statement that actually works,
would be nice. 

Thanks,

:)

On Thursday 21 October 2010 19:16:16 Neeraj Chand wrote:
> How would I go about running a stored procedure call from asterisk via
> func_odbc.
Check an ODBC reference to be sure, but the template would probably
be somewhere along the lines of:
readsql={ CALL sp_foo(${ARG1}) }

http://msdn.microsoft.com/en-us/library/ms403294.aspx
> I'm after an example entry in func_odbc if possible for ast 1.4
> 
> Also, if someone could post an insert statement that actually works,
> would be nice.
writesql=INSERT INTO foo (bar) VALUES ('${VAL1}')

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org