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, MINand MAX of some fields. These are all bringing back the expected resultsinto 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 listhad concluded it was an error (bug) in WebDNA.I've tried wrapping the results in various FORMAT and MATH contexts, butnothing 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 terabytelevels and so I need to decide whether or not to continue with WebDNA aspart of the solution.Christian F. GurneyManaging DirectorKG InterDev, LLCcfgurney@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:
In my mySQL sql query, I'm using some aggregate functions to get AVG, MINand MAX of some fields. These are all bringing back the expected resultsinto 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 listhad concluded it was an error (bug) in WebDNA.I've tried wrapping the results in various FORMAT and MATH contexts, butnothing 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 terabytelevels and so I need to decide whether or not to continue with WebDNA aspart of the solution.Christian F. GurneyManaging DirectorKG InterDev, LLCcfgurney@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)