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:
Anyone using Verisign's Payflow Link for payment processing? (2000)
WCf2 and nested tags (1997)
License for Sale? (2003)
Re:E-Mailer (WebCatb15acgiMac) (1997)
WebCat2b12--[searchstring] bug (1997)
OT - How to pay commissions to non US affiliates? (2000)
PCS Frames (1997)
HTML Editors (1997)
Math (1997)
Huge databases and RAM (1998)
[sendmail] (2000)
[WebDNA] Override price in Wd8.5 (2017)
TCPConnect / Current Temperature (2004)
Automatic thumbnail images (1998)
Cart Question (1998)
XML Syntax, Cookies and Variables.... (2004)
[OT] Mom's gift (2006)
Reminder... (2003)
Replace Statement (1997)
Not really WebCat- (1997)