search for: odbcrows

...t by the include => internal, and run through the [internal] context as follows: [internal] exten => _3XX,1,NoOp() same => n,Set(E=${EXTEN}) same => n,Set(${E}_VMCONTEXT=${HOTDESK_INFO(vmcontext,${E})}) same => n,Set(USER_LOCATION=${HOTDESK_USER_STATUS(${E})}) same => n,GotoIf($[${ODBCROWS} < 1]?notloggedin) same => n,Dial(SIP/${USER_LOCATION},20,wWU(blf-begincall^${E}^INUSE)b(blf-begincall^s^1(${E}^RINGING))) same => n,Voicemail(${E}@${${E}_VMCONTEXT},b) same => n,Hangup() same => n(notloggedin),Set(LOGGED_OFF=1) same => n,Voicemail(${E}@${${E}_VMCONTEXT},u) same =...

...me => n,Set(CALLERID(num)=${${WHO}_CID_NUMBER}) same => n,Goto(users,${EXTEN},1) [users] include => internal [internal] exten => _1XX,1,Verbose(5,Internal user - ${EXTEN}) same => n,Set(E=${EXTEN}) same => n,Set(USER_LOCATION=${HOTDESK_USER_STATUS(${E})}) same => n,GotoIf($[${ODBCROWS} < 1]?notloggedin) same => n,Dial(SIP/${USER_LOCATION},20,wWU(blf-begincall^${E}^INUSE)b(blf-begincall^s^1(${E}^RINGING))) same => n,Voicemail(${E}@rsnwo,b) same => n,Hangup() same => n(notloggedin),Set(LOGGED_OFF=1) same => n,Voicemail(${E}@rsnwo,u) same => n,Hangup() [blf-be...

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,