similar to: func_odbc questions

Hello, Now I'm testing func_odbc and hash. My configurations are: func_odbc.conf [GETNUMBER] dsn=sqlserver ;mode=multirow ;rowlimit=10 readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers WHERE number=${SQL_ESC(${ARG1})} extensions.conf exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(NUMERIS=37037210602) exten =>

All, Thank you in advance for any help. I have a customer in need of a conferencing system. A requirement is for users to each have their own PIN for the same bridge. So, I put the list of users, PINs bridges into a MYSQL DB and used an ODBC connector to parse the table. Asterisk is connected and reads the rows as expected. The problem is that if a user enters a PIN that is NOT in the table,

Hi All Anyone know how to do include files with func_odbc.conf? I now have several pages of functions in my func_odbc.conf and it is getting harder to maintain it. I would like to break them up into files by category. The standard method of using the #include does not seem to work . Ideas are appreciated. Bryant -------------- next part -------------- An HTML attachment was

Hi: I need help merging rows. I am trying to merge the 'Month' column using \multirow. For example for the column 'Week' I want July to be merged into one row(weeks 27,28,29,30) and so on for the following weeks. Below, I am creating a PDF using Sweave, MikTex,R-2.8.1 and windows XP to show an example. \documentclass[11pt]{article} \usepackage{longtable,verbatim} \title{How to

Hi all, I have a series of measurements made over different types of road surfaces and capacity that I want to summarize in tables via LaTeX. Ideally I'd like a table similar to this ( http://www.andy-roberts.net/misc/latex/tutorial4/multirow.png ) with mean/SD of the measurement broken down by road type (both surface and capacity). Ideally it would be extensible so that when I add layers

Dear List, I have an asterisk 1.6.2 installation. I'm trying to configure func_odbc to read some mysql tables... but every time I tried I got this message: ERROR[24968] func_odbc.c: Unable to execute query [SELECT bloqueada FROM funciones WHERE extension='750'] I'm sure the DSN is right because I can do this: [root at grupodelavega asterisk]# su - asterisk [asterisk at

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, :)

Hey All, Odd thing. I am just trying to return the whole date time stamp from a SMALLDATETIME field in a MS SQL server. func_odbc.conf = readsql=SELECT DateCreated FROM [REDACTED] WHERE Code = '${ARG1}' Problem is I only get the first 15 back from the field. Like so... Connected to Asterisk 1.8.6.0 currently running on [REDACTED]-dev (pid = 2240) Verbosity is at least 3

Is func_odbc still working in trunk? I've recently (in the last few weeks) started having a problem where my custom functions don't work. The module loads, the configuration file is parsed fine, and the functions are even created and visible in "core show functions", but when executed from the dialplan I get a "no such function" error. Here's a bit of console

This is primarily aimed at Sir Lesher, whose name graces the source code for func_odbc that I'm currently trying to read to answer this question. Tilghman (or anyone else who has determined the answer to this query), I have googled, searched wikis, and I'm currently perusing the source code, but the long and short of it is that I cannot seem to find any reference to variables set by

Hello everyone, I would be extremely glad if someone could help me with the following issue: cat /etc/asterisk/func_odbc.conf [call_user] prefix=GET dsn=asterisk_odbc_sip readsql=SELECT name FROM asterisk_sippeers WHERE name = '%477' Asterisk CLI show the following issue: -- Executing [205 at phones_wildcard:1] NoOp("SIP/Y_MD_vlungu_477-00000008",

with func_odbc, in the definitive asterisk guide, they were suggesting the possibility that part, or perhaps all of, the dialplan could be written as SQL statement!? First off, that sounds like a good idea to me, but the tone of the authors was suggesting not so much, but that it was a personal preference. >From a naive perspective, why SQL statements at all? Why not just database config

Hello, we are migrating an Asterisk install from Trixbox/Asterisk 1.2 to Elastix 0.92 with asterisk-1.4.17 on CentOS 5. I need to migrate an funtion that consults a remote sybase database, using ODBC and freetds. On the new server I am able to connect to the database using isql without problems. When I try to connect from asterisk logs show: pbx.c: Function ODBC_SQL not registered Indeed I

Hi, I'm expiriencing very annoying issue with Asterisk while using ODBC on Linux box running Debian with following packages: Asterisk-node0:/tmp# dpkg -l | grep -i odbc ii libiodbc2 3.52.6-2 iODBC Driver Manager ii libmyodbc 3.51.15r409-4 the MySQL ODBC driver ii libodbcinstq1c2

Hi I have On func_odbc [EXEC] readhandle=ressqlserver writehandle=ressqlserver readsql=${ARG1} writesql=${ARG1} I'm trying an update on dialplan: exten=> 141,3,Set(dummy=${ODBC_EXEC(UPDATE Tabla set campo = ${EXTEN})}) On Cli: WARNING[3579]: func_odbc.c:353 acf_odbc_read: Error -1 in FETCH [UPDATE Tabla set campo = 4356] Any idea why is this?? The query

Is there any way to return multiple values from functions defined in func_odbc.conf? It appears that you can only return one value. True? Hope not.... Doug. ____________________________________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ -------------- next part

Hi to all. First of all exchuse for my bad english I try to use Ajax.InPlaceEditor with a textarea: ################## new Ajax.InPlaceEditor($(''ipblock''), ''tools/admin_save.php'', { ajaxOptions: {method: ''get''}, rows:10, cols:20, callback: function(form, value) { return ''op=ipblock&value='' + value},

I need to insert/update multiple MySQL columns in a single row with the func_odbc function at the SAME TIME. Someone showed me how to use ARRAY to retrieve multiple values at the same time, but I need to SET multiple values. Can this be done? If not, I will just stick with MySQL, but that's a pain in the ass because the asterisk-addons package has no default rpm spec file for building an

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using

An alternative solution that allows you to break it down by categories is in the functions below. Comments/suggestions welcome and encouraged. Note that much thanks is due to those who responded to an earlier post of mine on a similar topic. To use (assuming you have a data.frame falled pathDist with columns distances (your numeric data of interest), Capacity, Surface, and SITE (vectors of