Re: [WebDNA] MySQL float problems with WebDNA

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104593
interpreted = N
texte = --0016368e28fc406587047e14108e Content-Type: text/plain; charset=ISO-8859-1 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 --0016368e28fc406587047e14108e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Tue, Jan 26, 2010 at 5:51 AM, Toby Cox <toby.cox@netro42.co= m> wrote:
Anyone experienced strange things happening with the float data type and we= bdna?

I have this code

<!-- First connect up to the MySQL DB -->
[SQLConnect dbType=3DMySQL&host=3Dlocalhost&database=3Dmysqldb&= uid=3Dmyusername&pwd=3Dmypassword&conn_var=3Dconn1][/SQLConnect]
<!-- The execute my statement -->
[SQLExecute conn_ref=3Dconn1&result_var=3DmancodeAverage]SELECT * from = UR_mantotals WHERE mancode=3D'[mancode]';[/SQLExecute]

<!-- Retrieve results -->
[SQLResult result_ref=3DmancodeAverage][founditems][perf][/founditems][/SQL= Result]


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 displayin= g 1074655967

Using the same code, it will display all other fields properly ie:


ACTUAL DATA FROM MYSQL
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

FI =A0 =A0 =A03.65934 3.74359 3.87179 3.33333 3.35897 3.71795 4.15385 3.435= 9 =A039


DATA DISPLAYED BY WEBDNA
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
FI 1074611796 =A0 1074655967 =A0 =A0 =A01074655967 =A0 =A0 =A01074655967 10= 74655967 =A0 1074655967 =A0 =A0 =A01074655967 =A0 =A0 =A01074655967 1074655= 967 =A0 1074655967 =A0 =A0 =A01074655967 =A0 =A0 =A039



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 work= around for this.

=A0
This issue was fixed in WebDNA 6.2
<= /div>

--0016368e28fc406587047e14108e-- 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)
--0016368e28fc406587047e14108e Content-Type: text/plain; charset=ISO-8859-1 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 --0016368e28fc406587047e14108e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Tue, Jan 26, 2010 at 5:51 AM, Toby Cox <toby.cox@netro42.co= m> wrote:
Anyone experienced strange things happening with the float data type and we= bdna?

I have this code

<!-- First connect up to the MySQL DB -->
[SQLConnect dbType=3DMySQL&host=3Dlocalhost&database=3Dmysqldb&= uid=3Dmyusername&pwd=3Dmypassword&conn_var=3Dconn1][/SQLConnect]
<!-- The execute my statement -->
[SQLExecute conn_ref=3Dconn1&result_var=3DmancodeAverage]SELECT * from = UR_mantotals WHERE mancode=3D'[mancode]';[/SQLExecute]

<!-- Retrieve results -->
[SQLResult result_ref=3DmancodeAverage][founditems][perf][/founditems][/SQL= Result]


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 displayin= g 1074655967

Using the same code, it will display all other fields properly ie:


ACTUAL DATA FROM MYSQL
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

FI =A0 =A0 =A03.65934 3.74359 3.87179 3.33333 3.35897 3.71795 4.15385 3.435= 9 =A039


DATA DISPLAYED BY WEBDNA
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
FI 1074611796 =A0 1074655967 =A0 =A0 =A01074655967 =A0 =A0 =A01074655967 10= 74655967 =A0 1074655967 =A0 =A0 =A01074655967 =A0 =A0 =A01074655967 1074655= 967 =A0 1074655967 =A0 =A0 =A01074655967 =A0 =A0 =A039



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 work= around for this.

=A0
This issue was fixed in WebDNA 6.2
<= /div>

--0016368e28fc406587047e14108e-- JJ WebDNA

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:

WebCat2: Items xx to xx shown, etc. (1997) Silly Question (1997) Re:Version 2.0 and 1.6 simultaneous (1997) Last Minute addition to WildWebCAT98... (1999) First postarg not taking in $Commands (1997) Multiple Ad databases? (1997) Falsifying [BROWSERNAME] (1998) SASL Support in WebDNA (2004) Hiding usernames and passwords in URL (1998) OK, here goes... (1997) Webmerchant turns off (2000) Apache 2.0 incompatible? (2005) &FieldNametype=time unnecessary? (2000) Nested vs conditional (1997) linetiems in thankyou.tpl (1997) RequiredFields notes ... (1997) remotely creating and populating a stock inventory db - almost there! (1999) Help name our technology! I found it (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) THANKS (1997)