Maybe because dbh has no 'execute' method? Try with: dbh:query(sql) Regards, François. On Tue, 2013-02-12 at 14:15 +0000, Archana Venugopan wrote:
Hi,
I tried executing a simple DB query in lua script in freeswitch.
dbh:execute{"Select * from dir_users"}
But I got this error
2013-02-12 14:09:56.247165 [ERR] mod_lua.cpp:198 /usr/local/freeswitch/scripts/directory.lua:184: attempt to call method 'execute' (a nil value)
stack traceback:
/usr/local/freeswitch/scripts/directory.lua:184: in main chunk
2013-02-12 14:09:56.247165 [ERR] mod_lua.cpp:264 LUA script parse/execute error!
Can anyone please point what is the mistake I have done and why execute method is not being recognised? Thanks.
Regards,
Archana
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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