MySQL 5/Float

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68349
interpreted = N
texte = 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. In MySQL, the price column has type "float." Anyone else have problems with MySQL columns with type float? Code example below. Breaks added for legibility. [sqlconnect dbtype=MySQL &host=216.168.63.56 &database=mydatabase &uid=myname &pwd=mypass &conn_var=conn1] [/sqlconnect] [sqlexecute conn_ref=conn1&result_var=rs4] SELECT subtotal FROM transaction WHERE orderid = '103352'; [/sqlexecute] [sqlresult result_ref=rs4] [founditems] [subtotal] [/founditems] [/sqlresult] ------------------------------------------------------------- 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'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. In MySQL, the price column has type "float." Anyone else have problems with MySQL columns with type float? Code example below. Breaks added for legibility. [sqlconnect dbtype=MySQL &host=216.168.63.56 &database=mydatabase &uid=myname &pwd=mypass &conn_var=conn1] [/sqlconnect] [sqlexecute conn_ref=conn1&result_var=rs4] SELECT subtotal FROM transaction WHERE orderid = '103352'; [/sqlexecute] [sqlresult result_ref=rs4] [founditems] [subtotal] [/founditems] [/sqlresult] ------------------------------------------------------------- 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:

Plugin or CGI or both (1997) carriage returns in data (1997) Setting up WebCatalog with Retail Pro data (1996) SMSI - MacWorld (2005) Problems with cybercash (2000) Unexpected error (1997) Slow Server (2005) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Search in 2 or more catalogs (1997) Sorry But This seems to be my fate (2000) Configuration for WebDNA (2006) WebCat2b13MacPlugIn - More limits on [include] (1997) Webmerchant confirmation hooks? (1997) Setting up WebCatalog with Retail Pro data (1996) Dubble Sku's in a Database (1999) Emailer errors - repost (2000) Creating comums (1998) Letters as SKU (1998) Random question (1998) Can ShowNext do this? (2000)