Re: MySQL 5/Float

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68351
interpreted = N
texte = I was able to work around it by formatting the fields in my SELECT statement like this: SELECT FORMAT(price,2) as pricef FROM mytable WHERE ... On 1/22/07 12:10 PM, "Jesse Proudman" wrote: > This is a MySQL / WebDNA compatibility bug and you need to get a > patched version from SM to make it work. > > -- > > Jesse Proudman, Blue Box Group, LLC > > > > > On Jan 22, 2007, at 9:18 AM, Clint Davis wrote: > >> I'm using to WebDNA to pull numeric values from MySQL 4.0.x table >> and add >> them up. I upgraded to MySQL 5.0.x and noticed that the addition isn't >> working any more. For example, a record with "21.1" in the "price" >> column is >> displayed as "1077221785" in my WebDNA [founditems] loop. ------------------------------------------------------------- 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 5/Float ( Clint Davis 2007)
  2. Re: MySQL 5/Float ( Jesse Proudman 2007)
  3. MySQL 5/Float ( Clint Davis 2007)
I was able to work around it by formatting the fields in my SELECT statement like this: SELECT FORMAT(price,2) as pricef FROM mytable WHERE ... On 1/22/07 12:10 PM, "Jesse Proudman" wrote: > This is a MySQL / WebDNA compatibility bug and you need to get a > patched version from SM to make it work. > > -- > > Jesse Proudman, Blue Box Group, LLC > > > > > On Jan 22, 2007, at 9:18 AM, Clint Davis wrote: > >> I'm using to WebDNA to pull numeric values from MySQL 4.0.x table >> and add >> them up. I upgraded to MySQL 5.0.x and noticed that the addition isn't >> working any more. For example, a record with "21.1" in the "price" >> column is >> displayed as "1077221785" in my WebDNA [founditems] loop. ------------------------------------------------------------- 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/ Clint Davis

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:

Problems. (2000) Sorting by date (1997) Only charge card when product shipped ? (1997) Error with [applescript] (1999) WebCatalog seems to choke on large (2meg) html files. (1998) [WebDNA] [listwords] and [index] (2009) [WebDNA] Manually push a new .db for WebDNA to adapt (2017) (2006) [SHOWIF] (1997) include bug????? (1997) [append] (1997) Error 11 (1996) ShowIf variables (1997) Trouble with PIXO and Welcome Plugin (1999) RE: Questions To Answer (1997) HELP WITH DATES (1997) variables in [addlineitem] (1998) OT: .biz and .info (2001) more ! testing (1997) Protecting Images (2003)