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,000TCOn 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:
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,000TCOn 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)