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:

Need help with emailer- 2 issues (1997) minimalist shopping cart. (1997) sendmail error (2001) Search in 2 or more catalogs (1997) Encyption mail was Suggestions for Topics ... (1998) OT: Javascript Form Validation (2002) include bug????? (1997) Umm...about those log files? (Off Topic) (1997) OT - How to pay commissions to non US affiliates? (2000) WebCat2: Formulas.db question (1997) Share Bulletin Board? (1998) Show shoppingcart after remove last item (1997) [URL] around a [sendmail] recipient? (2000) request for new command (1997) [WebDNA] Carriage Return/Line Feed Issue (2009) using showpage and showcart commands (1996) [WebDNA] Commas within table content (2009) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Setting up the server (1997) Extended [ConvertChars] (1997)