Re: SM: MySQL and Numbers (BUG)
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62841
interpreted = N
texte = Yes, it's an internal dev. version. On Aug 24, 2005, at 9:27 AM, Clint Davis wrote: > 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/ > > -- Jesse Proudman Blue Box Group, LLC p. +1.800.613.4305 x801 e. jesse@blueboxgrp.com ------------------------------------------------------------- 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:
Yes, it's an internal dev. version. On Aug 24, 2005, at 9:27 AM, Clint Davis wrote: > 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/ > > -- Jesse Proudman Blue Box Group, LLC p. +1.800.613.4305 x801 e. jesse@blueboxgrp.com ------------------------------------------------------------- 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/
Jesse Proudman
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:
listfiles shows invisible files ... (1999)
Snake Bites (1997)
Problem with summary on date / inconsequent webcat behaviour (1998)
Capacity question (2002)
OSX 10.2.6/iTools 7.0/WebDNA 5.0 installation (2003)
HTML encoding in URLs (1997)
Zip Codes (2003)
[quantity] within formulas (1997)
WebSite and *NO* Authentication Dialog Box!!? (1998)
Locking up with WebCatalog... (1997)
Shipping Help! (1998)
NetForms for email (1998)
More on the email templates (1997)
Stat analyzer (1997)
Same DB Same Time (2004)
the dreaded unitShipCost (2003)
Printing a final order (1997)
(ot) sitemap generator (1998)
HomePage Caution (1997)
Time code! (2002)