Re: aggregate count and group by

2005-02-25 Thread Jim Grill
Jim Grill <[EMAIL PROTECTED]> wrote on 02/18/2005 03:17:39 PM: Hi, I need some SQL guru help on this one. I'm trying to re factor an existing application where a number of clicks grouped by keyword for two different time periods are needed. For example, a user picks a date range and the applic

Re: aggregate count and group by

2005-02-22 Thread SGreen
Jim Grill <[EMAIL PROTECTED]> wrote on 02/18/2005 03:17:39 PM: > Hi, > > I need some SQL guru help on this one. > > I'm trying to re factor an existing application where a number of clicks > grouped by keyword for two different time periods are needed. For > example, a user picks a date rang

aggregate count and group by

2005-02-18 Thread Jim Grill
Hi, I need some SQL guru help on this one. I'm trying to re factor an existing application where a number of clicks grouped by keyword for two different time periods are needed. For example, a user picks a date range and the application selects a count for how many times a keyword appears in a

Re: RE: Count and group by problems

2002-08-17 Thread Egor Egorov
Menard, Friday, August 16, 2002, 8:44:38 PM, you wrote: M> Me again M> I found a work around to my problem: M> select country, count(distinct client_name, client_address, etc..) clients M> from addresses group by country M> But I still don't understand why the below would not work. I downloaded

RE: Count and group by problems

2002-08-16 Thread Menard, Inc. Information Systems
elp. Help. Thanks Jake -Original Message- From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 5:26 PM To: David Kramer; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Count and group by problems For an example let's say that I

RE: Count and group by problems

2002-08-14 Thread Menard, Inc. Information Systems
st 09, 2002 5:59 PM To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED] Subject: RE: Count and group by problems Im not sure I understand what it is that you are trying to do here??? Im assuming your using PERL/SomeScriptingLang on something on NT to connect to mysql using

Re: Count and group by problems

2002-08-12 Thread Francisco
Interesting a spooky. Try to use different cursor types. As you know, ADO, or better said, OLE DB behaves (or misbehaves) depending on the cursor. Have you tried a FORWARD and READ ONLY cursor. Good Luck --- "Menard, Inc. Information Systems" <[EMAIL PROTECTED]> wrote: > Evening > > I think I'm

RE: Count and group by problems

2002-08-09 Thread David Kramer
DK -Original Message- From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 3:10 PM To: [EMAIL PROTECTED] Subject: Count and group by problems Evening I think I'm losing my mind. I have a very simple query that works fine in MySQLFront but will not wor

Count and group by problems

2002-08-09 Thread Menard, Inc. Information Systems
Evening I think I'm losing my mind. I have a very simple query that works fine in MySQLFront but will not work when I connect using ADO: select booger, count(*) from nose group by booger If I try the above query with one record It works fine. Once I try it with more records, nothing returns. I

Count and Group By

2002-04-05 Thread Edilson Vasconcelos de Melo Junior
Hi, I hava a table "tblA" that has two fields (id, description) and a table "tblB" with two fields (fk_tblA, dtInsert). My problem is that i need to count records in tblB grouping them by (id, description) to know how many children each record from tblA has in tblB. The sql i'm using is: