SM: MySQL and Numbers (BUG)
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62838
interpreted = N
texte = The following query executed via command line or phpMyAdmin returns the correct price with 2 decimal places: SELECT thumb, title, itemid, price, round( price, 2 ) FROM items WHERE quantity >0 ORDER BY RAND( ) LIMIT 2 The same query executed via WebDNA DOES NOT WORK. The price is returned as a long string of numbers like: 1076756480 This has to be a WebDNA bug. For the record, I'm running WebDNA 6.0a under MacOS X Server 10.2.8. On 8/22/05 10:31 AM, "Clint Davis"
wrote: > 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:
The following query executed via command line or phpMyAdmin returns the correct price with 2 decimal places: SELECT thumb, title, itemid, price, round( price, 2 ) FROM items WHERE quantity >0 ORDER BY RAND( ) LIMIT 2 The same query executed via WebDNA DOES NOT WORK. The price is returned as a long string of numbers like: 1076756480 This has to be a WebDNA bug. For the record, I'm running WebDNA 6.0a under MacOS X Server 10.2.8. On 8/22/05 10:31 AM, "Clint Davis" wrote: > 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:
Confirmation emails classified as junk (2000)
ExclusiveLock question (2005)
restart needed???? (1997)
Problems reading files created by WC (1997)
search form problem.. (1997)
Beginning Documentation (2002)
Formatting ModDate (2000)
[WebDNA] WebSite Examples (2008)
RE: E-mailer error codes (1997)
osx or redhat and / or other (2005)
WebDNA processes only one page at a time? (2002)
Now you see it now you donīt (1997)
Encrypted Templates Serving as Text (2000)
Webcatalog and foreign languages (1998)
Trouble with formula.db + more explanation (1997)
WebCat2 - many [carts] on one template page? (1997)
Emailer [cart] file names (1997)
E-Mail (1998)
Using Plug-In while running 1.6.1 (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)