search for: odbc_exec

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 works fine, I just wanto to know if the warning can cause any problem to me. Thanks!! Sebastian ---...

...o insert it into a SQL server database. But I cannot see results into the variable, it always return NULL. Here is a piece of the AGI. fwrite(STDOUT,"exec Read my_var|/sound_to_play|5|||15 \n"); fflush(STDOUT); $conn=odbc_connect('MSSQL', 'USER', 'PASS'); $query = odbc_exec($conn, "INSERT INTO dialed(number) VALUES('$my_var')"); Even if I only show my_var value or try to use it inside asterisk, the value is NULL. There is another way to do it? Am I doing a mistake here? I'm using Asterisk 1.2.13. Thank you all. -- Ralph Liebessohn ICQ: 748359...

Ok, sorry for the response on the same thread. This is a new one. The main thing is that with this I set the Store Procedure or Query directly on the dialplan line, is easier to configure, change, manage, etc. I also know that works great with heavy load, and it reconnects when the network goes down and up. Can you help me porting this app? I think woun`t be difficult for someone that

On 1/11/07, Mike D'Ambrogia <miked@jamagination.com> wrote: > > Ralph > > Kind of new to asterisk, and really new to AGI but it looks like you were > trying to have the AGI script tell asterisk to read and lay the results into > my_var and then regain control in the AGI script, is that correct? > > If so I don't think that will work since the dialplan