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:
| |
- 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:
Weird Math and SV (1997)
Shopping Carts folder does not exist in Linux (2000)
Math Context (2001)
listfiles-looking for slick solution (1997)
Recursion & WebDNA (1999)
'page impression' techniques for banner ads (1999)
Renaming textA (1998)
WebCatalog/Mac 2.1b2 New Features (1997)
[WebDNA] [listwords] seems especially slow (amongst the looping contexts) (2010)
Oracle XE (2006)
OT: JavaScript question (2001)
[WebDNA] TCPDoh (2009)
gateway application timeouts (1998)
Summary search -- speed (1997)
Sending Email (2004)
webcat- multiple selection in input field (1997)
problems with 2 tags (1997)
email server and webdna (2006)
Exclude by date - multiple (1997)
WC2b12: Yes, Formulas.db is for real (1997)