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:

    
  1. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  2. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  3. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  4. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  5. SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
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)