How about?
select count(*)
from myTable
where searchtext = 'dave'
and date between date1 and date2
*****************
Guess I wasn't clear, I dont need the total number of records, I need a
breakdown
What I'm storing is search parameters...so if someone searched for "dave"
ten
times during the week then rather than spit out "dave" over ten lines the
ouput would read 10 searches for "dave".
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: [EMAIL PROTECTED]
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
