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

[John Carpenter]

Thats it, changed connection to a pgsql:// dsn and I get four decimal
places, changed it back to ODBC and back to 3 decimal places.
Thanks very much, been driving me mad

On 23 March 2015 at 10:23, Steven Ayre <steveayre at gmail.com> wrote:

> 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
>>
>
>
> _________________________________________________________________________
> 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/3f4c0387/attachment.html