Re: MySQL and Numbers
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62824
interpreted = N
texte = I'm also using 4.0.18...On 8/22/05 10:24 AM, "Thierry Almy"
wrote:> 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:
I'm also using 4.0.18...On 8/22/05 10:24 AM, "Thierry Almy" wrote:> 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/
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:
[Announce]: Web server security and password protection (1997)
Off Topic: SNMP over TCP/IP (1998)
Replace Statement (1997)
Date math format (1998)
purchase.log file (1997)
File Upload (1997)
Bug? (1997)
Emailer (WebCat2) (1997)
More DateMath problems (1997)
[OT] Theiving B*****ds (2004)
redirect problem - bug? (2003)
Secure server question (1997)
WebCatalog2 Feature Feedback (1996)
Date search - yes or no (1997)
Difficult Alternating Problem (2001)
Help! WebCat2 bug (Ben's input) (1997)
300% usage - Clint (2007)
WC1.6 to WC2 date formatting (1997)
Plugin or CGI or both (1997)
Help! WebCat2 bug (1997)