All pastes #59648 Raw Edit

Untitled

public text v1 · immutable
#59648 ·published 2006-05-29 19:57 UTC
rendered paste body
Actual Dialplan Code:
 
exten => 1111,3,MYSQL(Query resultid ${connid} SELECT\ conf_room_id\ from\ cst_conf_rooms\ where\ conf_room_id=${CON_ID})
exten => 1111,4,MYSQL(Fetch fetchid ${resultid} CONRM)
exten => 1111,5,Noop(CONRM=${CONRM})
exten => 1111,6,Set(confroom=${CONRM})
exten => 1111,7,Noop(confroom=${confroom})
exten => 1111,8,MYSQL(Clear ${resultid})
exten => 1111,9,MYSQL(Disconnect ${connid})
exten => 1111,10,Noop(confroom=${confroom})
exten => 1111,11,MeetMe(${confroom},,12345)
 
 
Result:

    -- Executing MYSQL("SIP/203-49b4", "Query resultid 15 SELECT conf_room_id from cst_conf_rooms where conf_room_id=10000") in new stack
    -- Executing MYSQL("SIP/203-49b4", "Fetch fetchid 16 CONRM") in new stack
    -- Executing NoOp("SIP/203-49b4", "CONRM=10000") in new stack
    -- Executing Hangup("SIP/203-49b4", "") in new stack
  == Spawn extension (main, 1111, 6) exited non-zero on 'SIP/203-49b4'