Re: MySQL and Numbers
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62820
interpreted = N
texte = I have a field called price setup as a float. An item costing $20.00 would show in the table as simply 20. I need to format the price to 2 decimal places. When I run the following query, I get a weird number like 1078034432: SELECT thumb,title,itemid,price FROM items where viewable='Yes' ORDER BY RAND() limit 2; When I try to format the field in the following query, I get nothing: SELECT thumb,title,itemid,price,FORMAT(price,2) FROM items where viewable='Yes' ORDER BY RAND() limit 2; On 8/21/05 6:21 AM, "Thierry Almy"
wrote: > It worked for me, but the filed names are different: >> Select ean, format(preis,2) as myprice > > I even could to it like this: >> Select ean, format(preis,2) as preis > and then referring to the original filedname [preis] > > Maybe "price" is a reserved variablename or expression?! > > Post your SQL Query in here to verify! > Thierry > > >> I also have a field named "price" in a table. The field is spec'ed as FLOAT, >> and a price of $20.00 would show in the table as just 20. When I pull the >> price from the table, it displays some weird number like 1074987008. I tried >> the format code below, but it doesn't show anything when I insert [myprice] >> into the [founditems] loop. >> >> Any ideas? >> >>> Select ean, format(price,2) as myprice >>>> Where xxxxx >>>> >>>> Then get it within WebDNA as [myprice]. ------------------------------------------------------------- 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:
I have a field called price setup as a float. An item costing $20.00 would show in the table as simply 20. I need to format the price to 2 decimal places. When I run the following query, I get a weird number like 1078034432: SELECT thumb,title,itemid,price FROM items where viewable='Yes' ORDER BY RAND() limit 2; When I try to format the field in the following query, I get nothing: SELECT thumb,title,itemid,price,FORMAT(price,2) FROM items where viewable='Yes' ORDER BY RAND() limit 2; On 8/21/05 6:21 AM, "Thierry Almy" wrote: > It worked for me, but the filed names are different: >> Select ean, format(preis,2) as myprice > > I even could to it like this: >> Select ean, format(preis,2) as preis > and then referring to the original filedname [preis] > > Maybe "price" is a reserved variablename or expression?! > > Post your SQL Query in here to verify! > Thierry > > >> I also have a field named "price" in a table. The field is spec'ed as FLOAT, >> and a price of $20.00 would show in the table as just 20. When I pull the >> price from the table, it displays some weird number like 1074987008. I tried >> the format code below, but it doesn't show anything when I insert [myprice] >> into the [founditems] loop. >> >> Any ideas? >> >>> Select ean, format(price,2) as myprice >>>> Where xxxxx >>>> >>>> Then get it within WebDNA as [myprice]. ------------------------------------------------------------- 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:
Email Newsletters (2003)
RE: HTTP Header info (1997)
WebDNA color code chart - help (2002)
Date in IF ELSE Comparison (2004)
JavaScript Image Problem (1998)
random images (1997)
Printing a final order (1997)
SiteEdit NewFile.html ? (1997)
Re:2nd WebCatalog2 Feature Request (1996)
OS X (2000)
But with European Dates? (2006)
OT: Unix Find Question (2004)
Format of Required fields error message (1997)
WebCat2.0 acgi vs plugin (1997)
My own list archives (2001)
More NT encyption!! (1999)
Proposed FormVariables hierarchy (2000)
PSC recommends what date format yr 2000??? (1997)
Am I being really stupid? (2003)
emailer (1997)