Re: MySQL and Numbers
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62818
interpreted = N
texte = 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:
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/
Thierry Almy
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:
Return records from another (1997)
Only charge card when product shipped ? (1997)
Search Question (2003)
Email Set-Up? (1997)
OT: CSS and Positioning (2001)
I'm new be kind (1997)
Emailer file formats (1998)
dates and hex formatting (1997)
WebCat2.0 [format thousands .0f] no go (1997)
two unique banners on one page (1997)
ups quickcost [repost] (1999)
Don't tick me off :) [elaspedtime] (1997)
Delete only one duplicate record? (2003)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Less than or equal to........ (1997)
[WebDNA] anybody notice issues with convertchars FF3.5 mac (2009)
File Upload (1997)
Setting up WebCatalog with Retail Pro data (1996)
unable to launch acgi in WebCat (1997)
DataBaseHelper Flawed (1997)