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. Larry On 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 OFFICE HCO, LLC360.807.1103 FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.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:

    
  1. Re: MySQL and Decimals ( "Sal" 2004)
  2. Re: MySQL and Decimals ( Larry Hewitt 2004)
  3. Re: MySQL and Decimals ( John Peacock 2004)
  4. Re: MySQL and Decimals ( Larry Hewitt 2004)
  5. Re: MySQL and Decimals ( Larry Hewitt 2004)
  6. Re: MySQL and Decimals ( Larry Hewitt 2004)
  7. Re: MySQL and Decimals ( John Peacock 2004)
  8. MySQL and Decimals ( Larry Hewitt 2004)
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. Larry On 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 OFFICE HCO, LLC360.807.1103 FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.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)