Re: mySQL GROUP BY Aggregate Function Problem

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 61089
interpreted = N
texte = You could try formatting in the query so the values are returned as text.>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/-- --------------------------------- John A. Hill Oak Hill SoftwareWebsite Development/Consulting john@oakhillsoftware.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:

Re: mySQL GROUP BY Aggregate Function Problem ( John Peacock 2005)
Re: mySQL GROUP BY Aggregate Function Problem ( John Hill 2005)
mySQL GROUP BY Aggregate Function Problem ( "Christian F. Gurney" 2005)

You could try formatting in the query so the values are returned as text.>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/-- --------------------------------- John A. Hill Oak Hill SoftwareWebsite Development/Consulting john@oakhillsoftware.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/ John Hill

DOWNLOAD WEBDNA NOW!

Re: mySQL GROUP BY Aggregate Function Problem

2005

Top Articles:

Related Readings: