Posted by DaFerg on 08/27/06 08:00

Hi ...
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 ...
tblWebLog.[cs-uri-stem]

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 ...

Update tblStrings
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?

Cheers.

• Next in forum: Re: Counting the occurence of a string ...
• Prev in forum: Re: Merging two tables with selection
• Thread view: Counting the occurence of a string ...

[Reply to this message]