--set default variables
        max_digits = 15;
        digit_timeout = 5000;
        debug["sql"] = true;

--connect to the database
        require "resources.functions.database_handle";
        dbh = database_handle('system');

--set the api
        api = freeswitch.API();

--get the argv values
        action = argv[2];

--get the session variables
        if (session:ready()) then
                session:answer();
        end

--get the session variables
        if (session:ready()) then
                --general variables
                        dnfrom = session:getVariable("dnfrom");
                        uuid = session:get_uuid();
                        rnoroute = session:getVariable("rnoroute");

        end


--get the routing code
        sql = "SELECT rnoroute FROM ported_number ";
        sql = sql .. "WHERE dnfrom = '" .. dnfrom .."' ";
                --set the variables
                        dnfrom = row.dnfrom;
                        rnoroute = row.rnoroute;

--show the results
        if (dnfrom) then
                freeswitch.consoleLog("notice", "routing code " .. dnfrom .. " dnfrom: " .. dnfrom .. "\n");
        end