The Group By makes them PageTo distinct with the group >> Select v1.PageTo, count(distinct v1.PageTo) from common.visits V1 >> Group By v1.pageTo
Try Select PageTo, count(v1.PageTo) from common.visits group By pageTo Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Mark Weiss [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 11:14 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Custom DBMS Actions Witango/Primebase 3.5running on Mac OS 9 Thanks for the try, But no go. Still no results. Mark On 3/5/03 10:14 AM, "Atrix Wolfe" <[EMAIL PROTECTED]> wrote: > mark, try this maybe: > > Select PageTo, count(distinct PageTo) from visits Group By pageTo > > the common.visits could be the problem since you dont need to (and cant!) > specify the name of the datasource within a DBMS since you already do that > in the settings. > > ----- Original Message ----- > From: "Mark Weiss" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; "PrimeBase-Talk" > <[EMAIL PROTECTED]> > Sent: Wednesday, March 05, 2003 10:01 AM > Subject: Witango-Talk: Custom DBMS Actions Witango/Primebase 3.5 running on > Mac OS 9 > > >> Hi, >> >> I am confused as to why this might be the case. >> >> If I run this query in PrimeBase Client 3.0 >> >> Select v1.PageTo, count(distinct v1.PageTo) from common.visits V1 Group By >> v1.pageTo >> >> I get just the results I would expect, >> >> But if I run this in WiTango 4.0 using a custom DBMS action, I get no >> results. >> >> And If I debug and look at the query it shows me: >> >> Select v1.PageTo, count(distinct v1.PageTo) from common.visits V1 Group By >> v1.pageTo >> >> So it is passing exactly the right stuff but no results. >> >> If I do a >> >> select * from common.visits >> >> It returns the right results just fine. So is it the Count function? >> >> So that may be a problem with Tango. Have you every heard of Custom DBMS >> actions not working in Witango/Primebase? >> >> Thanks for any help you can offer. >> >> Mark Weiss >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
