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:

    
  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)
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:

Separate SSL Server (1997) Generating unique SKU from [cart] (1997) Include a big block of text (1997) syntax question, not in online refernce (1997) 2.0 Info (1997) [append] and SSL (1997) [numfound] in nested [search] (2000) Looking for a host (1997) Server Freeze (1998) WebDNA 4.5 & iTools 7 (2003) pop up menu's (1998) da webcat, da merchant, da auth (1998) SSL, WebSTAR, WebCatalog (1998) Seeking Better Display of results... (1997) expired beta (1997) Sandbox DB permissions (2005) process code only if accessed via POST (2006) Initiating NewCart (1997) E-Mail Preferences in Admin Folder (1997) more on my bbs (1997)