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 integer vendor = 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:

    
  1. 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 integer vendor = 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)