Re: SM: MySQL and Numbers (BUG)
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62839
interpreted = N
texte = 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 > -- 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:
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 > -- 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:
[SameAsShipping] (2005)
WCS Newbie question (1997)
RequiredFields template (1997)
writing db to disk (1997)
Migrating to NT (1997)
Running _every_ page through WebCat ? (1997)
Referrer field to header field conversion (1997)
New index for docs (1997)
WebCat with WebTen (1998)
Thanks Grant (1997)
Type 11 errors setting up WebCAt 2 (1997)
[protect] on NT? (1997)
triggers (2003)
Cookies? (1997)
[interpret] inside the db field? (1997)
WebDNA v5 Hosting (2003)
Taxable Shipping (2003)
Webcatalog, Webstar and Crasharama (1999)
Emailer setup (1997)
RE: WebCatalog2 for NT Beta Request (1997)