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:
sorting dates (1999)
[WebDNA] Send Mail and SMTP Host (2015)
quantity minimum problem (1997)
Re:Signal Raised (1997)
Old Style vs XML Syntax (2003)
Document Contains no data, or showcart error. (1997)
WebDNA vs SQL ? (2002)
WebCat2: Items xx to xx shown, etc. (1997)
New [If] command question (2000)
Renaming TextA (1998)
downloading a file in it's own browser window? (2002)
Problems searching from a FORM (1997)
Problem with ShoppingCart.tpl refresh (2000)
Ads.db (1997)
WebCommerce: Folder organization ? (1997)
WC TableGrinder (1997)
emailer (1997)
Database Strategy - more... (1998)
Setting up shop (1997)
syntax question, not in online refernce (1997)