Re: SM: MySQL and Numbers (BUG)
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62842
interpreted = N
texte = Hmmmm....Any other changes in this dev version that you know of?On 8/24/05 11:33 AM, "Jesse Proudman"
wrote:> 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/
Associated Messages, from the most recent to the oldest:
Hmmmm....Any other changes in this dev version that you know of?On 8/24/05 11:33 AM, "Jesse Proudman" wrote:> 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/
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:
Logging purchases (1997)
Configuring E-mail (1997)
Templates on Unix & CGI on Mac? (1997)
Not really WebCat (1997)
Shhh... (2006)
Replace Statement (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Frames and WebCat (1997)
When do we get to request new features? (1999)
No luck with taxes (1997)
Press Release hit the NewsWire!!! (1997)
WebCatalog for Postcards ? (1997)
2.1 Stuff (1998)
Re:Emailer and encryption (1997)
[WebDNA] Email not going out, error 554 (2016)
[TaxableTotal] - not working with AOL and IE (1997)
WebCat2: multiple currency support (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Trigger alternatives please ... (2004)
GuestBook example (1997)