Hello,

You'll have to have a working odbc connection, as mentioned by Steven, but then here's a Lua code snippet to test your stuff:

-- connect to DB via ODBC
local dbh = freeswitch.Dbh("odbc://freeswitch:freeswitch:PASS")
if dbh:connected() == false then
  freeswitch.consoleLog("error", " Cannot connect to database.\n")
  return
end

-- looping through the db results
freeswitch.consoleLog("info", " Looping through the DB results")
sql_query = "SELECT id,name FROM your_table LIMIT 10;"
dbh:query(sql_query, function(row)
    -- do whatever you want with row.FIELD_NAME, for instance:
    freeswitch.consoleLog("info", "id:" .. tostring(row.id))
end)


Hope it helps ;)
Florent

2014-09-16 21:37 GMT+02:00 Aqs Younas <aqsyounas@gmail.com>:
Thanks for your quick reply. I give it a try.

On 17 September 2014 00:21, Steven Ayre <steveayre@gmail.com> wrote:
Configure an ODBC connection to the database, then use freeswitch.Dbh from lua


On 16 September 2014 18:41, Aqs Younas <aqsyounas@gmail.com> wrote:
Hello, Users

i am newbie to freeswitch.I want to write lua script for querying data for mysql database that i could use in lua script.

Could someone please specify me how to do this with small exemplary lua script code.
or

1.) How to make freeswitch connect to mysql for querying data

2.) All steps in this regard.

Thanks

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.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