mySQL GROUP BY Aggregate Function Problem

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61088
interpreted = N
texte = In my mySQL sql query, I'm using some aggregate functions to get AVG, MIN and MAX of some fields. These are all bringing back the expected results into a mySQL query editor. However, in WebDNA 6.0a on WIN2K, they are not. Nitai had reported a simliar issue with DATE functions and I think the list had concluded it was an error (bug) in WebDNA. I've tried wrapping the results in various FORMAT and MATH contexts, but nothing makes any difference. Data is returned, but instead of being like "40.02" it comes back as "-13098634258232". The mySQL fieldtypes are DECIMAL. Anyone got any ideas? I'm dealing with data sets that are going to rapidly blossom to terabyte levels and so I need to decide whether or not to continue with WebDNA as part of the solution. Christian F. Gurney Managing Director KG InterDev, LLC cfgurney@kginterdev.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:

    
  1. Re: mySQL GROUP BY Aggregate Function Problem ( John Peacock 2005)
  2. Re: mySQL GROUP BY Aggregate Function Problem ( John Hill 2005)
  3. mySQL GROUP BY Aggregate Function Problem ( "Christian F. Gurney" 2005)
In my mySQL sql query, I'm using some aggregate functions to get AVG, MIN and MAX of some fields. These are all bringing back the expected results into a mySQL query editor. However, in WebDNA 6.0a on WIN2K, they are not. Nitai had reported a simliar issue with DATE functions and I think the list had concluded it was an error (bug) in WebDNA. I've tried wrapping the results in various FORMAT and MATH contexts, but nothing makes any difference. Data is returned, but instead of being like "40.02" it comes back as "-13098634258232". The mySQL fieldtypes are DECIMAL. Anyone got any ideas? I'm dealing with data sets that are going to rapidly blossom to terabyte levels and so I need to decide whether or not to continue with WebDNA as part of the solution. Christian F. Gurney Managing Director KG InterDev, LLC cfgurney@kginterdev.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/ "Christian F. Gurney"

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:

Help! WebCat2 bug (1997) [format 40s]text[/format] doesn't work (1997) Frames and WebCat (1997) shownext not showing next...still r2 (1997) unable to launch acgi in WebCat (1997) numfound=0 for a search after going into the SSL (2003) Answer: WebDelivery downloads alias, not original ? (1997) Navigator 4.01 (1997) Categorizing by data (2001) form data submission gets truncated (1997) [OT] USPS Shipping Cost calculation (2000) random prob (2003) Sorting by highest number of matches unique to a field (2003) WebCat2b15MacPlugin - [protect] (1997) [WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016) switching users (1998) latest version? (1998) Summing fields (1997) errormessages.db (1997) [WebDNA] OSX Webdna Installer (2009)