Thanks for the reply Doug!

How might I incorporate this into my dialplan?

Sorry, learning as I go....

On a side note, any idea how to strip off the # at the end of a string?  
${EXTEN:0:6} doesn't do the trick.

Is this even possible?

Pat...

 

From: [email protected] 
[mailto:[email protected]] On Behalf Of Doug Lytle
Sent: Thursday, April 18, 2013 7:29 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] ODBC dialplan looping problem

 

>> The problem is that if a user enters a PIN that is NOT in the table, 
>> asterisk goes crazy and continues to loop forever.

 

Why don't you use read instead?  This is what I have:

 

exten => s,n,Answer(500)
exten => s,n,Read(get-room-num,conf-getconfno)

; *********************************************************
; Get conference room number, if number entered is 99999 **
; jump to verify.                                        **
; *********************************************************

exten => s,n,NoOP(${conf-getchannel})

 

Do some mysql magic here

 

exten => s,n,GotoIf($["${conference.room}" != ""]?s-process,1:s-notexist,1)

 

Doug

-- 

Ben Franklin quote:

 

"Those who would give up Essential Liberty to purchase a little Temporary 
Safety, deserve neither Liberty nor Safety."

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to