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