Re: SM: MySQL and Numbers (BUG)
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62840
interpreted = N
texte = They have a version later than 6.0a?On 8/24/05 11:21 AM, "Jesse Proudman"
wrote:> SM has an updated version of 6 that fixes this. See if you can get a> copy.> > On Aug 24, 2005, at 8:40 AM, Clint Davis wrote:> >> 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 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:
They have a version later than 6.0a?On 8/24/05 11:21 AM, "Jesse Proudman" wrote:> SM has an updated version of 6 that fixes this. See if you can get a> copy.> > On Aug 24, 2005, at 8:40 AM, Clint Davis wrote:> >> 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 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:
color (1999)
too many nested tags ... (1997)
Permission denied? (2004)
Sitebuilder (2004)
too many nested ... problem (1997)
Duplicate Cart #'s (1998)
Still having problems with Authen (1997)
WebCatalog can't find database (1997)
Help! WebCat2 bug (1997)
[include] and v.email (1998)
Re:upgrade problem with users.db (1998)
Webcatalog Plugin for Quid Pro Quo not working (2000)
For those of you not on the WebCatalog Beta... (1997)
Firesite and [referrer] atg broke (1997)
Rendering out a page (1997)
[include] (1998)
building / customizing stores (2000)
Search/sort in URL Was: GuestBook example (1997)
[OT] IANA Special Use (2004)
[searchString] (1997)