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:
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!
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:
emailer (1997)
2.0 Info (1997)
[isfile] ? (1997)
default value from Lookup (was Grant, please help me) (1997)
RE: Adding headers to email (1997)
multi-paragraph fields (1997)
Dumb Question about Docs (1997)
Random tags HELP!!!! (1999)
HTML Editors (1997)
[OT] HTML, HTML docs (2001)
FM PRO Compatibility Issue - Single Database w/o Conversions (1997)
SSL with IIS 4.0 (1998)
Search for value or blank? (2004)
Multipart/alternative e-mail (2003)
Sample Tearoom Search Error (1997)
in header include files? (1998)
Formulas (2001)
[delete] problem (1997)
Great product and great job ! (1997)
HTML Emails To Eudora For Windows (2005)