webdna/mysql aggregate function bug?
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69564
interpreted = N
texte = Hi all,I'm trying to run this mysql query:[SQLExecute conn_ref=39&result_var=get_cost]SELECT vendor,shipmethod,SUM(wt) AS ttl_wt FROM cart_shiptemp WHERE kart = '[kart]' AND vendor = '[vendor_id]' GROUP BY shipmethod[/SQLExecute]....but the ttl_wt value is blank. COUNT(wt) works fine, but AVG(wt) does not (also blank).My table config is:id = int(11)kart = varchar(20)wt = int(11) <--- all input to this field is sanitized to be an integervendor = char(3)shipmethod = varchar(10)Has anyone else run into this, or found a workaround?-------------------------------------------------------------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:
|
- webdna/mysql aggregate function bug? ( Phil Herring 2007)
|
Hi all,I'm trying to run this mysql query:[SQLExecute conn_ref=39&result_var=get_cost]SELECT vendor,shipmethod,SUM(wt) AS ttl_wt FROM cart_shiptemp WHERE kart = '[kart]' AND vendor = '[vendor_id]' GROUP BY shipmethod[/SQLExecute]....but the ttl_wt value is blank. COUNT(wt) works fine, but AVG(wt) does not (also blank).My table config is:id = int(11)kart = varchar(20)wt = int(11) <--- all input to this field is sanitized to be an integervendor = char(3)shipmethod = varchar(10)Has anyone else run into this, or found a workaround?-------------------------------------------------------------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/
Phil Herring
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:
(2000)
TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997)
Formula Question (1998)
[WriteFile] problems (1997)
Searching for all records (1998)
vs (1997)
WebCat2: multiple currency support (1997)
invoice.tpl (1998)
[BULK] Fwd: [WebDNA] [BULK] WebDNA discovery in the Console - [having many crashes] (2011)
Upgrading old WebCat Database Files (1997)
WebCat2b12 - nesting [tags] (1997)
denied access (1997)
Re:2nd WebCatalog2 Feature Request (1996)
WebCatalog NT beta 18 problem (1997)
WebCatalog2 Feature Feedback (1996)
Credit card types (1997)
[cart] not being interpreted inside [founditems] (1997)
Re:trouble (1997)
Whats going on with my SERIAL NUMBER??? (1998)
Founditems context returning only 1 item (1997)