Wow, Just have never encountered SQL Syntax like this :-b With debug on you can see how Witango is setting up the queries, might help
Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WitangoGoodies.htm -----Original Message----- From: Mark Weiss [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 10:35 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Custom DBMS Actions Witango/Primebase3.5running on Mac OS 9 Ben, Thanks for the response I tried that and I get a Primebase error that says it is looking for the distinct in the query. Error An error occurred while processing your request: File: Majestic.taf Position: DirectDBMS3 Class: DBMS Main Error Number: -10005 [Snap][ODBC PrimeBase Driver]"[API]"@client line 1: DISTINCT token expected in place of 'PageTo' 37000 File: Majestic.taf Position: DirectDBMS3 Class: Internal Main Error Number: -101 General error during data source operation. I sent the API log to Barry Leslie at Primebase. There may be some kind of bug here. Or perhaps I don't have the most up to date Primebase extension or ODBC Driver for 3.5. Something isn't right though. Thanks again. Mark On 3/5/03 2:41 PM, "Ben Johansen" <[EMAIL PROTECTED]> wrote: > 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 > ________________________________________________________________________ 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
