search for: odbc_fetch

...UMBER2,STATUSAS)=${ODBC_GETVARIABLES(${NUMERIS})}) exten => s,n,Verbose(1| ${NUMERIS}, ${REALNUMBER1} ${REALNUMBER1}, ${STATUSAS}) But I don't know how to retrieve data, if query returns a lot of rows. In documentation I read that need to use in config file: mode=multirow, and use function ODBC_FETCH. But how to get result-id variable and use ODBC_FETCH? And another question is, if I execute not SELECT , but stored procedure, and this procedure will return two, three tables? Is it possible retrieve these data from couple tables? Thanks -- Pagarbiai / Best Regards, Giedrius Augys -------...

...,1) exten=_8XXXXX,1,Goto(getpin,${EXTEN},1) exten=_9XXXXX,1,Goto(getpin,${EXTEN},1) exten=i,1,Goto(getpin,${CONF_PIN},1) ; [getpin] exten=_XXXXXX,1,Set(GLOBAL(CONF_PIN)=${EXTEN}) exten=_XXXXXX,n,Set(ODBC_ID=${ODBC_PIN(1)}) exten=_XXXXXX,n(loop_start),NoOp() exten=_XXXXXX,n,Set(ROW_RESULT=${ODBC_FETCH(${ODBC_ID})}) exten=_XXXXXX,n,GotoIf($["${ODBC_FETCH}" = "FAILURE"]?cleanup,1) exten=_XXXXXX,n,GotoIf($["${ROW_RESULT}" = "${CONF_PIN}"]?good_exten,1) exten=_XXXXXX,n,Goto(loop_start) ; exten=cleanup,1,Verbose(1,Finish up) same=n,Verbose(1,PIN not foun...