Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Odd results when searching for a string of numbers

1 view
Skip to first unread message

Vic

unread,
May 24, 2010, 7:51:05 PM5/24/10
to
Hi,

I am working with classic asp on Windows 2008 and I have setup a
IXSSO.Query that searches for a string of numbers, for example
10000000001. When I run this search I receive results that also
include variations to this, like 10000000002 10000000003 and so on.

If I change the first digit so the search string is 20000000001 I dont
get anything. If I keep moving the last digit from my first example to
the left, I keep getting hits until I reach the half way point when I
get no results! So in other words 10000020000 will return results like
in the first example but 10000200000 does not.

This all sounds like to me that its doing a match on the first 6
characters and it ignores the rest.

Here is relevant parts of the

Set oQuery = Server.CreateObject("IXSSO.Query")
oQuery.Catalog = SEARCH_CATALOG
oQuery.Query = "@all " & searchstr
Set oRS = oQuery.CreateRecordset("nonsequential")

Anyone got any ideas what is going on? Is this normal behavior and is
it adjustable?

Thanks, Vic.

0 new messages