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 with database strategy (1998) Multiple prices (1997) Forcing a NEWCART (1997) IE Cache Problems... (1999) AOL and webcat (1998) Odd Cart Behavior (1997) [WebDNA] Why doesn't this returnraw redirect to the new page? (2009) Format question WC Mac f3 (1997) Date/Time format problems (1997) Replace and Date (2002) Next (1997) More on the email templates (I like it) (1997) PSC recommends what date format yr 2000??? (1997) TCPconnect & XML (2008) b12 cannot limit records returned and more. (1997) shownext & math (1997) Where's Cart Created ? (1997) major search problem (1998) multi-paragraph fields (1997) HELP WITH DATES (1997)