Re: Counting the occurence of a string ...

Giganews Newsgroups
Subject: Re: Counting the occurence of a string ...
Posted by:  Roy Harvey (roy_harv…
Date: Sun, 27 Aug 2006

If tblStrings.[strSearch] is defined as fixed length (char) instead of
varying length (varchar) that would cause problems.  Or if trailing
blanks were stored in a varchar column.  Try using
RTRIM(tblStrings.[strSearch]) instead.

Roy Harvey
Beacon Falls, CT

On 27 Aug 2006 01:00:04 -0700, "DaFerg" <da…> wrote:

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



In response to

Counting the occurence of a string ... posted by DaFerg on 27 Aug 2006