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:
In Digest Dijon (2000)
Weird Math and SV (1997)
Now you see it now you donīt (1997)
docs for WebCatalog2 (1997)
Bug? (1997)
Multiple Choices in One Entry - Clothing Sizes (2000)
Emailer setup (1997)
math on date? (1997)
ANSWER to: CC Merchant suggestions?? (1997)
Latest beta slow on [order] and [purchase] (1997)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
Summing fields (1997)
security (1997)
[OT] Networking 3 printers wirelessly (2005)
August 15th WebDNA Chat Transcript (2002)
Nested search index (2000)
NY taxRates.db? (1997)
Need relative path explanation (1997)
Location of Browser Info.txt file (1997)
Hard Questions ? (1997)