Re: mySQL --- problem??

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59220
interpreted = N
texte = I have had to use the FLOOR() function around certain numbers brought in as variables to get them to display correctly. Not sure why, but it works. OSX, WebCat6,. MySQL 4 Larry On Aug 30, 2004, at 12:43 PM, Brian Boegershausen wrote: > Anyone had a problem displaying a variable from mysql that is setup as > a > float data type in the table. > I am getting very odd results. The data shows up fine if I look it up > using > php, but in webdna the number is drastically off. > > Windows 2003 Webserver Edition > WebDNA 6 > > Brian > > > > ------------------------------------------------------------- > 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 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- 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 --- problem?? ( John Peacock 2004)
  2. Re: mySQL --- problem?? ( "Brian Boegershausen" 2004)
  3. Re: mySQL --- problem?? ( Larry Hewitt 2004)
  4. mySQL --- problem?? ( "Brian Boegershausen" 2004)
I have had to use the FLOOR() function around certain numbers brought in as variables to get them to display correctly. Not sure why, but it works. OSX, WebCat6,. MySQL 4 Larry On Aug 30, 2004, at 12:43 PM, Brian Boegershausen wrote: > Anyone had a problem displaying a variable from mysql that is setup as > a > float data type in the table. > I am getting very odd results. The data shows up fine if I look it up > using > php, but in webdna the number is drastically off. > > Windows 2003 Webserver Edition > WebDNA 6 > > Brian > > > > ------------------------------------------------------------- > 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 109 No. Tower360.880.4855 CELL P.O. Box 1017larryh@hewittco.com Centralia, WA 98531www.votewashington.org www.hewittco.com ------------------------------------------------------------- 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:

Bug Report, maybe (1997) WC Database Format (1997) Initiating NewCart (1997) Public beta 6 for WebCatalog 4.0 is now available (2000) WC2b15 File Corruption (1997) E-mailer error codes (1997) [ConvertChars] problem (1997) texta,b,c,d,e (urgent) (2003) emailer (1997) Announcing general availabilty of WebDNA 4.5 release (2002) Thread (1999) Looking for WebDNA calendar (2004) Passing Username and Password on the command line (2000) Who is doing sign-ups-got it (1998) Looking up two prices in database? (1997) Another form question (2000) Error:Too many nested [xxx] contexts (1997) Review comparison by PC Magazine: Open for On-lineBusiness (1997) Three new problems, maybe a fourth (1997) Generate a SKU (1998)