[Freeswitch-users] Problem with LUA dbh:query in Freeswitch

[Steven Ayre]

Have you tried a pgsql:// dsn? In case the ODBC driver is having some
truncating effect.

On 22 March 2015 at 02:06, John Carpenter <carpenter.john at gmail.com> wrote:

> I am trying to use Lua to retrieve some currency conversion rates from a
> postgres database. It works but the numeric field value is only returning
> the first three decimal places although if I list the data in postgres it
> has four decimal places. I may be doing something daft as I am quite new to
> Lua, sample code is below. Any ideas appreciated
>
> regards, John
>
>
>  local dbh = freeswitch.Dbh("odbc://fs_odbc:fs_user:password")
> if dbh:connected() == false then
>  freeswitch.consoleLog("notice", "dp.lua cannot connect to database" ..
> dsn .. "\n")
>  return
> end
> assert(dbh:connected())
>
> e_rate = 1.123456789
> -- just a test to see decimal places
> freeswitch.consoleLog("info",string.format(" e_rate = %f", e_rate))
>
> local function eur2usd()
>    local sql = "select eur2usd from currency order by id desc limit 1"
>    dbh:query(sql, function(row)
>        e_rate = row.eur2usd
>        end)
> end
>
> local function eur2gbp()
>    local sql = "select eur2gbp from currency order by id desc limit 1"
>    dbh:query(sql, function(row)
>        e_rate = row.eur2gbp
>        end)
> end
>
> eur2usd()
> freeswitch.consoleLog("info",string.format(" euro2usd = %f", e_rate))
> eur2gbp()
> freeswitch.consoleLog("info",string.format(" euro2gbp = %f", e_rate))
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150323/ad9de2a8/attachment.html