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:
Web Catalog 2 demo (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Whats wrong with this code? (1998)
Only charge card when product shipped ? (1997)
CommandSecurity? (1997)
WC2b15 File Corruption (1997)
WebCat, The Trend, & Consolidating... (1997)
More news on 5.0 (2003)
Search in 2 or more catalogs (1997)
Shareware Listserver (1998)
Shell script within a sandbox (2005)
FEATURE REQUEST: (was: Summarizing results. Is there a shortcut? (1999)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Errata: WCS Newbie question (1997)
WriteFile Formatting (2000)
ExclusiveLock (2000)
2 databases problem (1997)
I'm new be kind (1997)
rename a file (1997)
WebCat and WebTV (1997)