<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I’m not much of a programmer, but can’t you specify a format to %f to force it to return 4 decimal places?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Or is that not available in Lua?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Bote<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> John Carpenter<br><b>Sent:</b> Monday, 23 March, 2015 06:59<br><b>Subject:</b> Re: [Freeswitch-users] Problem with LUA dbh:query in Freeswitch<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>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. <o:p></o:p></p></div><p class=MsoNormal>Thanks very much, been driving me mad<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 23 March 2015 at 10:23, Steven Ayre <<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>> wrote:<o:p></o:p></p><div><p class=MsoNormal>Have you tried a pgsql:// dsn? In case the ODBC driver is having some truncating effect.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><div><div><p class=MsoNormal>On 22 March 2015 at 02:06, John Carpenter <<a href="mailto:carpenter.john@gmail.com" target="_blank">carpenter.john@gmail.com</a>> wrote:<o:p></o:p></p></div></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><div><div><p class=MsoNormal style='margin-bottom:12.0pt'>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<o:p></o:p></p></div><p class=MsoNormal>regards, John<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><b><span style='font-family:"Courier New";color:black;background:#F3F3F3'>local</span></b><span style='font-family:"Courier New";color:black;background:#F3F3F3'> dbh = freeswitch.Dbh(<b>"odbc://fs_odbc:fs_user:password"</b>) <br><b>if</b> dbh:connected() == <b>false</b> <b>then</b> <br> freeswitch.consoleLog(<b>"notice"</b>, <b>"dp.lua cannot connect to database"</b> .. dsn .. <b>"\n"</b>) <br> <b>return</b> <br><b>end</b> <br><b>assert</b>(dbh:connected()) <br><br>e_rate = <b>1.123456789</b> <br><b>-- just a test</b> to see decimal places<br>freeswitch.consoleLog(<b>"info"</b>,<b>string.format</b>(<b>" e_rate = %f"</b>, e_rate)) <br><br><b>local</b> <b>function</b> eur2usd() <br> <b>local</b> sql = <b>"select eur2usd from currency order by id desc limit 1"</b> <br> dbh:query(sql, <b>function</b>(row) <br> e_rate = row.eur2usd <br> <b>end</b>) <br><b>end</b> <br><br><b>local</b> <b>function</b> eur2gbp() <br> <b>local</b> sql = <b>"select eur2gbp from currency order by id desc limit 1"</b> <br> dbh:query(sql, <b>function</b>(row) <br> e_rate = row.eur2gbp <br> <b>end</b>) <br><b>end</b> <br><br>eur2usd() <br>freeswitch.consoleLog(<b>"info"</b>,<b>string.format</b>(<b>" euro2usd = %f"</b>, e_rate)) <br>eur2gbp() <br>freeswitch.consoleLog(<b>"info"</b>,<b>string.format</b>(<b>" euro2gbp = %f"</b>, e_rate))</span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></blockquote></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></body></html>