Re: MySQL and Numbers
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62822
interpreted = N
texte = The following code displays nothing for the [myprice] variable... [sqlconnect dbtype=MySQL&host=myipaddress&database=mydatabase&uid=myuser&pwd=mypass&conn _var=conn1][/sqlconnect] [sqlexecute conn_ref=conn1&result_var=rs1] SELECT thumb,title,itemid,FORMAT(price,2) AS myprice FROM items WHERE viewable='Yes' ORDER BY RAND() limit 2; [/sqlexecute] [sqlresult result_ref=rs1] [founditems] [thumb]*[title]*[itemid]*[myprice] [/founditems] [/sqlresult] On 8/22/05 9:08 AM, "nitai@computeroil.com"
wrote: > You are missing to ALIAS the Formated price. Try this: > > SELECT > thumb,title,itemid,FORMAT(price,2) AS myprice > FROM > Items > WHERE viewable='Yes' > ORDER BY RAND() limit 2; > > Then you can use [myprice] in your WebDNA code. > > Nitai >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of >> Clint Davis >> Sent: Montag, 22. August 2005 14:15 >> To: WebDNA Talk >> Subject: Re: MySQL and Numbers >> >> 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:
The following code displays nothing for the [myprice] variable... [sqlconnect dbtype=MySQL&host=myipaddress&database=mydatabase&uid=myuser&pwd=mypass&conn _var=conn1][/sqlconnect] [sqlexecute conn_ref=conn1&result_var=rs1] SELECT thumb,title,itemid,FORMAT(price,2) AS myprice FROM items WHERE viewable='Yes' ORDER BY RAND() limit 2; [/sqlexecute] [sqlresult result_ref=rs1] [founditems] [thumb]*[title]*[itemid]*[myprice] [/founditems] [/sqlresult] On 8/22/05 9:08 AM, "nitai@computeroil.com" wrote: > You are missing to ALIAS the Formated price. Try this: > > SELECT > thumb,title,itemid,FORMAT(price,2) AS myprice > FROM > Items > WHERE viewable='Yes' > ORDER BY RAND() limit 2; > > Then you can use [myprice] in your WebDNA code. > > Nitai >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of >> Clint Davis >> Sent: Montag, 22. August 2005 14:15 >> To: WebDNA Talk >> Subject: Re: MySQL and Numbers >> >> 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:
Add a field to the error log? (1997)
WebCat2b12 - nesting [tags] (1997)
FEA REQ: One .hdr, multiple .db's (2003)
Sizes/Colors Options (2006)
Moment of Thanks (1997)
Where's Cart Created ? (1997)
useful guidelines =] vs !] (2007)
Multiple TCPConnects (2002)
Email and name capture (1999)
(1997)
NT Email Stops Sending (2000)
Error Lob.db records error message not name (1997)
Using [sendmail] for mass mailings (2001)
Using Applescript to process WebCatalog functions (1998)
garbage on page (2000)
WC2.0 Memory Requirements (1997)
Exclamation point (1997)
OS X and cart directories (2003)
Test (2003)
final on include (1997)