[WebDNA] MySQL float problems with WebDNA

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104584
interpreted = N
texte = 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 ====================== FI3.659343.743593.871793.333333.358973.717954.153853.435939 DATA DISPLAYED BY WEBDNA ======================== FI 1074611796107465596710746559671074655967 10746559671074655967 10746559671074655967 10746559671074655967107465596739 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. Any guidance appreciated. Using WebDNA version 6.0a on a Mac Server TC 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)
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 ====================== FI3.659343.743593.871793.333333.358973.717954.153853.435939 DATA DISPLAYED BY WEBDNA ======================== FI 1074611796107465596710746559671074655967 10746559671074655967 10746559671074655967 10746559671074655967107465596739 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. Any guidance appreciated. Using WebDNA version 6.0a on a Mac Server TC 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:

Don't tick me off :) [elaspedtime] (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) serial number generation (1997) Duplicate Carts (2006) P3P and IE 6 (2004) SQL db type (2006) different sized random banners (2003) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) target=_blank and form variables (1997) [WebDNA] php/mySQL version of WebDNA Speed Test? (2009) date and time stamp (2003) Stumpted Again (1997) Ampersand (1997) Include a big block of text (1997) Online reference (1997) controlling form elements (slightly OT) (2003) WebCat2b12 CGI Mac - [shownext] problem (1997) [OT] Looking to make hosting acquisition (2006) E-mailer error codes (1997) [WebDNA] Still having problems (2008)