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:

    
  1. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  2. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  3. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  4. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  5. SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  6. Re: MySQL and Numbers ( Clint Davis 2005)
  7. Re: MySQL and Numbers ( Thierry Almy 2005)
  8. Re: MySQL and Numbers ( Clint Davis 2005)
  9. Re: MySQL and Numbers ( nitai@computeroil.com 2005)
  10. Re: MySQL and Numbers ( Clint Davis 2005)
  11. Re: MySQL and Numbers ( Thierry Almy 2005)
  12. Re: MySQL and Numbers ( Clint Davis 2005)
  13. Re: MySQL and Numbers ( Thierry Almy 2005)
  14. Re: MySQL and Numbers ( nitai@computeroil.com 2005)
  15. MySQL and Numbers ( Thierry Almy 2005)
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)