Odd results when searching for numbers using IXSSO.Query
Posted
by Vic
on Stack Overflow
See other posts from Stack Overflow
or by Vic
Published on 2010-05-24T06:36:27Z
Indexed on
2010/05/24
6:41 UTC
Read the original article
Hit count: 337
Hi,
from classic asp on Windows 2008, using an IXSSO.Query, when searching for a string of numbers, for example 10000000001, 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 and/or suggestions?
Thanks, Vic.
© Stack Overflow or respective owner