I'm preparing a simple homebrewed site statistics report for a client. I need to send
a cfmail each night showing the top pages viewed in various areas of the site. I'm
stumped on how to get the info I need from the db.
The table involved is a simple 5 column table. I just need to do a sql
something, but this should do it...
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 1:39 PM
To: CF-Talk
Subject: SQL ?: Counting number of times for this
I'm preparing a simple homebrewed site statistics report for a client. I
need to send
with Maxrows = the number of pages you want to show:
COUNTER: TITLE
COUNTER: TITLE
Etc.
I may be missing something, but this should do it...
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 1:39 PM
To: CF-Talk
Subject: SQL ?: Counting number
(searches.city))5))
ORDER BY count([city]) DESC;
Ian
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 2:32 PM
To: CF-Talk
Subject: RE: SQL ?: Counting number of times for this
Ian,
I'm sorry - I don't know what you mean. What is COUNTER and TITLE
;
Ian
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 10, 2002 2:32 PM
To: CF-Talk
Subject: RE: SQL ?: Counting number of times for this
Ian,
I'm sorry - I don't know what you mean. What is COUNTER and TITLE? I'm
assuming you're meaning
BY script_name
ORDER BY Count(script_name) DESC
Jim
- Original Message -
From: Paul Sinclair [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, February 10, 2002 7:36 PM
Subject: RE: SQL ?: Counting number of times for this
Ian,
It is a pretty straightforward table in an MSSQL
(begindate)#
AND #CreateODBCDate(enddate)#
GROUP BY script_name
ORDER BY Count(script_name) DESC
Jim
- Original Message -
From: Paul Sinclair [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, February 10, 2002 7:36 PM
Subject: RE: SQL ?: Counting number of times
7 matches
Mail list logo
