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

[Abaci B]

I'm doing something very similar, this is what I use:

local rate = string.format("%.4f", currency]["rate"])


On Mon, Mar 23, 2015 at 8:45 AM, Ítalo Rossi <italorossib at gmail.com> wrote:

> Yep, it's available and defaults to 6 decimal places, but looks like it's
> not a Lua issue...
>
> On Mon, Mar 23, 2015 at 9:05 AM, Bote Man <bote_radio at botecomm.com> wrote:
>
>> I’m not much of a programmer, but can’t you specify a format to %f to
>> force it to return 4 decimal places?
>>
>>
>>
>> Or is that not available in Lua?
>>
>>
>>
>> Bote
>>
>>
>>
>>
>>
>> *From:* John Carpenter
>> *Sent:* Monday, 23 March, 2015 06:59
>> *Subject:* Re: [Freeswitch-users] Problem with LUA dbh:query in
>> Freeswitch
>>
>>
>>
>> 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
>>
>
>
>
> --
> Ítalo Rossi
>
> _________________________________________________________________________
> 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/f4f6fc23/attachment.html