Re: [WebDNA] MySQL float problems with WebDNA

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104594
interpreted = N
texte = Thanks - I checked the talklist first, but nothing came up for "float" I may try a workaround and use int and multiply my floating digits by 1,000,000 TC On 26 Jan 2010, at 16:49, JJ WebDNA wrote: > On Tue, Jan 26, 2010 at 5:51 AM, Toby Cox > wrote: > Anyone experienced strange things happening with the float data type > and webdna? > > I have this code > > > [SQLConnect > dbType > = > MySQL > &host > = > localhost > &database=mysqldb&uid=myusername&pwd=mypassword&conn_var=conn1][/ > SQLConnect] > > > [SQLExecute conn_ref=conn1&result_var=mancodeAverage]SELECT * from > UR_mantotals WHERE mancode='[mancode]';[/SQLExecute] > > > [SQLResult result_ref=mancodeAverage][founditems][perf][/founditems] > [/SQLResult] > > > The table UR_mantotals has 10 fields, one is a char(2) field, 8 are > float, and 1 is int(8) > > > Now, in the example above, perf is a float data type and although my > MySQL GUI app tells me that the real stored value is 3.65934, webDNA > is displaying 1074655967 > > Using the same code, it will display all other fields properly ie: > > > ACTUAL DATA FROM MYSQL > ====================== > > FI 3.65934 3.74359 3.87179 3.33333 3.35897 3.71795 4.15385 > 3.4359 39 > > > DATA DISPLAYED BY WEBDNA > ======================== > > FI 1074611796 1074655967 1074655967 1074655967 > 1074655967 1074655967 1074655967 1074655967 1074655967 > 1074655967 1074655967 39 > > > > As you can see, the int and char fields are fine, but the float > types have gone loopy. Has anyone experienced similar? Is this a bug? > > The float data type is required for this project, so I can't see a > workaround for this. > > > This issue was fixed in WebDNA 6.2 > Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] MySQL float problems with WebDNA (Toby Cox 2010)
  2. Re: [WebDNA] MySQL float problems with WebDNA (JJ WebDNA 2010)
  3. [WebDNA] MySQL float problems with WebDNA (Toby Cox 2010)
Thanks - I checked the talklist first, but nothing came up for "float" I may try a workaround and use int and multiply my floating digits by 1,000,000 TC On 26 Jan 2010, at 16:49, JJ WebDNA wrote: > On Tue, Jan 26, 2010 at 5:51 AM, Toby Cox > wrote: > Anyone experienced strange things happening with the float data type > and webdna? > > I have this code > > > [SQLConnect > dbType > = > MySQL > &host > = > localhost > &database=mysqldb&uid=myusername&pwd=mypassword&conn_var=conn1][/ > SQLConnect] > > > [SQLExecute conn_ref=conn1&result_var=mancodeAverage]SELECT * from > UR_mantotals WHERE mancode='[mancode]';[/SQLExecute] > > > [SQLResult result_ref=mancodeAverage][founditems][perf][/founditems] > [/SQLResult] > > > The table UR_mantotals has 10 fields, one is a char(2) field, 8 are > float, and 1 is int(8) > > > Now, in the example above, perf is a float data type and although my > MySQL GUI app tells me that the real stored value is 3.65934, webDNA > is displaying 1074655967 > > Using the same code, it will display all other fields properly ie: > > > ACTUAL DATA FROM MYSQL > ====================== > > FI 3.65934 3.74359 3.87179 3.33333 3.35897 3.71795 4.15385 > 3.4359 39 > > > DATA DISPLAYED BY WEBDNA > ======================== > > FI 1074611796 1074655967 1074655967 1074655967 > 1074655967 1074655967 1074655967 1074655967 1074655967 > 1074655967 1074655967 39 > > > > As you can see, the int and char fields are fine, but the float > types have gone loopy. Has anyone experienced similar? Is this a bug? > > The float data type is required for this project, so I can't see a > workaround for this. > > > This issue was fixed in WebDNA 6.2 > Toby Cox

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[OT][OT] OSX email client (2002) Fun with Dates - any progress? (1997) [WebDNA] SHA-512 How To Do It (2014) Running _every_ page through WebCat ? (1997) Add to Cart & List of Products (1997) Avery 5160 Mailing Labels SOLVED (2003) Timestamp/cart replacement was RE: Robust WebDNA Job Manager / (2006) WC TableGrinder (1997) Negative Range Error (2003) How far do [showif]s go? (1997) Deleting Orders (1997) WebCat b13 CGI -shownext- (1997) Mac: [ListFiles] bug alert (1997) WebDNA 5 - Function test weirdness or ? (2003) A few questions. . . (1997) Search wbrk word break param (1998) Internet Explorer and caching (2000) Ad Serving Software (2002) Posting form data to a popup (2004) WebCat2 beta FTP site (1997)