SQL Problem
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62543
interpreted = N
texte = Here is the command I'm running:SELECT SUM( list_stats_users.views ) , list_stats.mailingdate, list_stats.subjectFROM list_stats, list_stats_usersWHERE list_stats.site = '1'AND list_stats.mailingid = '25'AND ( list_stats.mailingid = list_stats_users.mailingid )GROUP BY list_stats.mailingidORDER BY list_stats.mailingdate DESC;Works fine running it through phpMyAdmin, and returns: SUM( list_stats_users.views ) mailingdate subject1 2005-07-11 12:43:07 Welcome To My New WebsiteWhen I run it through WebDNA, it returns: SUM( list_stats_users.views ) mailingdate subject1072693248 07/11/2005 12:43:07 Welcome To My New Website Notice the Sum in WebDNA is WAY off.Any one know how to fix this?--Jesse ProudmanBlue Box Group, LLCp. +1.800.613.4305 x801e. jesse@blueboxgrp.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:
|
- SQL Problem ( Jesse Proudman 2005)
|
Here is the command I'm running:SELECT SUM( list_stats_users.views ) , list_stats.mailingdate, list_stats.subjectFROM list_stats, list_stats_usersWHERE list_stats.site = '1'AND list_stats.mailingid = '25'AND ( list_stats.mailingid = list_stats_users.mailingid )GROUP BY list_stats.mailingidORDER BY list_stats.mailingdate DESC;Works fine running it through phpMyAdmin, and returns: SUM( list_stats_users.views ) mailingdate subject1 2005-07-11 12:43:07 Welcome To My New WebsiteWhen I run it through WebDNA, it returns: SUM( list_stats_users.views ) mailingdate subject1072693248 07/11/2005 12:43:07 Welcome To My New Website Notice the Sum in WebDNA is WAY off.Any one know how to fix this?--Jesse ProudmanBlue Box Group, LLCp. +1.800.613.4305 x801e. jesse@blueboxgrp.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/
Jesse Proudman
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:
Emailer choke (1997)
[taxrate] question (1997)
PROBLEM (1997)
Credit card types (1997)
Norton Internet Security filtering out WebDNA processsed (2004)
Still having problems with Authen (1997)
Pasting from M$ Word (2001)
Using WebMerchant Only? (1998)
RE: Credit card processing - UK (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
I need to get a [grep] (2003)
show all problem (1997)
Multiple prices (1997)
[ShowIf] and empty fields (1997)
GrandTotal not right (1997)
Re:Dumb Question about Docs (1997)
Virtual hosting and webcatNT (1997)
Force a search at the default.tmpl page? (1997)
smithmicro.com website? (2004)
OT: Unknown Webstar Error ruining presentation?! (2001)