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:
slow site (2003)
WC2b15 File Corruption (1997)
OT: Limit on # of Pulldown entries (1997)
Formating found categories (1997)
problems with 2 tags shakur (1997)
Storing dates (was: Ticket Ordering Question) (2003)
Database changes (1998)
Add to a field (1998)
WebCat2 several catalogs? (1997)
Don'y know if this is a sily question... (2003)
old problem (2001)
Extended [ConvertChars] (1997)
expired beta (1997)
Dates - Search and Sorting (1999)
Sorting by date (1997)
Searchable WebCat (etc.) Docs ? (1997)
Search results templates (1996)
TemplateCacheSize preference! (1998)
Is this google friendly? (2003)
Roundup function? (1997)