Have you specified in fs\conf\autoload_configs\spidermonkey.conf.xml that odbc should be loaded? On 8/29/08, mashudi <mashudiflexi@telkom.co.id> wrote:
it is already
use("ODBC");
var DSN = "DB"; var DB_USER = "conce"; var DB_PASS = "password";
var line = "====================================\n";
var db = new ODBC(DSN, DB_USER, DB_PASS); db.connect(); var sql; var dtmf = new Object(); var replay = 1;
function mycb (session, type, data, arg) {
if (type == "dtmf") { arg.digits += data.digit; if (arg.digits.length >= 1) { return false; } } }
function get_route(digits) {
sql = "select count(*) as count from conferences where pin = \"" + digits +"\";";
var line = "====================================\n";
console_log("notice", "Menu Option Entered: " + digits +" \n sql statment [" + sql + "]\n"); console_log("notice", line);
db.exec(sql);
while(db.nextRow()) { var row = db.getData(); if (row["count"] >= 1) { console_log("notice", "Found Conf Pin=[" + digits + "]\n"); return digits; } else {
and the odbc already running :
mashudi:/usr/local/freeswitch/scripts# isql -v DB +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL>
Jonas Gauffin wrote:
First you have to add
use("ODBC");
in your javascript.
On Thu, Aug 28, 2008 at 9:06 AM, mashudi <mashudiflexi@telkom.co.id> wrote:
Hi folks, i try javascripts example for conference application and get this error,
2008-08-28 20:59:55 [ERR] mod_spidermonkey.c:3303 js_api_use() Error loading ODBC 2008-08-28 20:59:55 [ERR] conference.js:10 mod_spidermonkey() ReferenceError: ODBC is not defined
i have follow the instruction as documented on http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc.
please help.
***************************************** Flexi-Gratis bicara sepanjang waktu se-Jawa Barat, Banten dan DKI Jakarta.
Speedy-Gratis Internetan unlimited dari Pkl. 20.00 s/d 8.00 se- Jabodetabek, Banten, Karawang dan Purwakarta *****************************************
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
***************************************** Flexi-Gratis bicara sepanjang waktu se-Jawa Barat, Banten dan DKI Jakarta.
Speedy-Gratis Internetan unlimited dari Pkl. 20.00 s/d 8.00 se- Jabodetabek, Banten, Karawang dan Purwakarta *****************************************
***************************************** Flexi-Gratis bicara sepanjang waktu se-Jawa Barat, Banten dan DKI Jakarta.
Speedy-Gratis Internetan unlimited dari Pkl. 20.00 s/d 8.00 se- Jabodetabek, Banten, Karawang dan Purwakarta *****************************************
_______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org