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

Filed under:
|
|

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

Related posts about iis

Related posts about indexing