|Subject:||Counting the occurence of a string ...|
|Posted by:||DaFerg (da…@myalarm.com)|
|Date:||27 Aug 2006|
I have a weblog database where I want to count the occurences of a
table of string values that appear in all the urls viewed.
My tblWebLog as a field that contains the url ...
I have another table ... tblStrings ... that has a field [strSearch]
for a string value and an integer field [intViewCount] to count the
occurence of the string in tblWebLog.[cs-uri-stem]
I've been trying ...
Set [intViewCount] = (Select Count(*) From tblWebLog Where
[cs-uri-stem] Like '%_' + tblStrings.[strSearch] + '.htm%')
.... but it doesn't fly and I'm stumped. Any thoughts?