Re: MySQL and Numbers
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62823
interpreted = N
texte = To me the code looks correct, we do it just like this ... using MySQL 4.0.18.>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]>-------------------------------------------------------------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:
To me the code looks correct, we do it just like this ... using MySQL 4.0.18.>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]>-------------------------------------------------------------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:
Deleting Multiple Database Records based on Checkbox (1998)
[WriteFile] problems (1997)
new storefront (2003)
WebCatalog.acgi quitting with error Type 2 (1998)
WC1.6 to WC2 date formatting -FIXED! (1997)
A Global Variable (1997)
Emailer Set Up (1997)
Still having problems with Authen (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
WC1.6 to WC2 date formatting (1997)
Form Weirdness (2002)
cart info (1998)
same products but different (1998)
Stumpted Again (1997)
Site Test Please (2005)
RE: IIS4b2 and WebCatalog b19 (1997)
[OT] Security in general [Was] WebDNA security (2004)
Searching Multiple DBs (1997)
RE: Re:Signal Raised (1997)
Emailer problem (1998)