2nd try... any mysql users in the house?
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69568
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:
| |
- 2nd try... any mysql users in the house? ( 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:
WebCat2b13MacPlugIn - More limits on [include] (1997)
Passing along data (2000)
emailer (1997)
multi-paragraph fields (1997)
Assigning new CART number (1997)
shownext & math (1997)
Page Counters? (1997)
GREP for search - not replace (2004)
Multiple catalog databases and showcart (1997)
Appending space (1998)
WebMerchant - MacAuthorize (1999)
Seeking Better Display of results... (1997)
Where's Cart Created ? (1997)
DON'T use old cart file! (1997)
OFF-TOPIC: For Gary Krockover ... (2003)
Quitting WebMerchant ? (1997)
different show next (1997)
PIXO with cometsite ... and/or other plugins (1998)
HELP WITH DATES (1997)
Remote delivery (1998)