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:

Looking up two prices in database? (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCatalog can't find database (1997) Emailer error 550? (1999) Paymethod question (1999) Multiple Replaces? (1997) [WebDNA] why is the webdna.us site slow? (sometimes?) (2011) GuestBook example (1997) [ot] Any One Want A WebDNA Billing Program? (2003) Summing fields (1997) Triggers and coupons (two questions) (2003) Where's Cart Created ? (1997) OT: 800x600 (2003) WebCatalog can't find database (1997) WebCatalog can't find database (1997) SiteEdit Pro Update Announcement (1997) Replace Statement (1997) Date Sorting (1997) PCS Frames (1997) Multiple catalog databases and showcart (1997)