Re: MySQL and Decimals
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57846
interpreted = N
texte = An FYI... I tried FLOAT and got the same result.I will redo the field type and reupload the data to see if that helps.Thanks.LarryOn May 14, 2004, at 10:21 AM, John Peacock wrote:> Larry Hewitt wrote:>> A database with fields defined as DECIMAL, size 10, 2 decimals allows >> me to enter or upload information just fine manually. When I try to >> read the data using the WEBDNA 6 SQL tags, I return the machine >> number equivalent, not the number: ie, 1074266112 instead of 2.0>> I suspect that not many people use the DECIMAL field type (usually > FLOAT is used). According to the docs DECIMAL values are actually > stored in MySQL as strings, which may be part of the problem (though I > have no idea why you would get such an odd "machine number" > representation like that).>> One thing you could try is applying various mathematical operations to > the field in your select statement:>> select dec_field+0 as new_dec, ...>> and see if WebCat deals with it appropriately...>> John>> -- > John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4501 Forbes Boulevard> Suite H> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5748>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/>>Larry Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX1133 Kresky NE #106360.508.6231 CELLCentralia, WA 98531larryh@hewittco.comwww.hewittco.comwww.votewashington.org-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
An FYI... I tried FLOAT and got the same result.I will redo the field type and reupload the data to see if that helps.Thanks.LarryOn May 14, 2004, at 10:21 AM, John Peacock wrote:> Larry Hewitt wrote:>> A database with fields defined as DECIMAL, size 10, 2 decimals allows >> me to enter or upload information just fine manually. When I try to >> read the data using the WEBDNA 6 SQL tags, I return the machine >> number equivalent, not the number: ie, 1074266112 instead of 2.0>> I suspect that not many people use the DECIMAL field type (usually > FLOAT is used). According to the docs DECIMAL values are actually > stored in MySQL as strings, which may be part of the problem (though I > have no idea why you would get such an odd "machine number" > representation like that).>> One thing you could try is applying various mathematical operations to > the field in your select statement:>> select dec_field+0 as new_dec, ...>> and see if WebCat deals with it appropriately...>> John>> -- > John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4501 Forbes Boulevard> Suite H> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5748>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/>>Larry Hewitt360.807.1100 OFFICEHCO, LLC360.807.1103 FAX1133 Kresky NE #106360.508.6231 CELLCentralia, WA 98531larryh@hewittco.comwww.hewittco.comwww.votewashington.org-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Larry Hewitt
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:
How to put the Trademark Symbol (%99) in Sendmail? (2003)
Help Please WebDNA 6 Secure Forms Problem (2004)
Windows nt service pack 3 upgrade (1997)
Server crash (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[replace] has protection feature like [delete]? (2000)
ListFiles and .DS_Store (2004)
Exclamation point (1997)
Bad Cookie / Internet Option / Internet Explorer (2004)
forming a SKU (1999)
taxRate is fine but taxTotal isn't (1997)
summ=T (2003)
Tcp Connect and IPaddress (2000)
[addlineitems] (1997)
WC2.0 Memory Requirements (1997)
Problems getting parameters passed into email. (1997)
[WebDNA] Decode Base64 Image (2019)
grouping fields question (1998)
Searching/sorting dates (1997)
Emailer not working (1998)