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:
Forbidden CGI Error (1997)
[WebDNA] [OT] BBEdit Glossary (2012)
[searchString] (1997)
Doing VALIDCARD right? (1998)
Admin Edit prob. (1997)
taxRate and grandTotal calculation is not showing up on my ThankYou.tpl (2000)
Re1000001: Setting up shop (1997)
Keep away (1997)
[ShowNext] feature in 2.0 (1997)
Running WebCat on a Virtual Server (2008)
ftp to webstar (2001)
2nd WebCatalog2 Feature Request (1996)
Searchable Archives (1998)
ThreadMem ignored? (1998)
WebCat b13 CGI -shownext- (1997)
Email (1998)
A few questions. . . (1997)
Security for malls with different webmasters (1998)
Emailer port change (1997)
text size limitation (1997)