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:

RE: Emailer Set Up (1997) Re[2]: POSTing to a secure server ... (2000) Upgrading old WebCat Database Files (1997) Weird Math and SV (1997) [showif],[refferer],[include] in errormessages.db (2002) Comments in db? (1997) SKU lookup (1997) WebCat2 - Getting to the browser's username/password data (1997) Hiding HTML and page breaks (1997) [WebDNA] WebDNA and Facebook (2009) Databases inside [SHOWIF] (1998) webcatalog [date] bug (1999) [ShowIf] and empty fields (1997) Cookie Newbie (2002) Not really WebCat (1997) Emailer (1998) Searching for words equal to A or equal to B (1999) 2.0 Info (1997) [Sum] function? (1997) Nested tags count question (1997)