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:

    
  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)
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)