Thunderstone Support Forums

Hi,
I have the following data,

DOCID OCR1
900 chief secretary's

When I do a search from TSQL,

tsql "select * from testtbl where OCR1 like 'w/10 chief secretary'";

I dont get the above record.
But when I do
run a vortex script which does the same,

I get a message ,
<!-- 115 rsvortex.txt:10: 'delimiters' not allowed in query -->
900 chief secretary's

But get the record back as hit.

Any reason why this descrepancy? I want the record as a hit in TSQL also. and what is the 'delimiters' message?

thanks!!

The message indicates that query protection in the Vortex script has ignored the delimiters. You will need to increase the number of characters in the delimiter to find that as a hit. The delimiter counts from the first word found, and all the other terms must exist within the region.

I have two questions
1. I changed the w/10 to w/100. Still I got the error, but it is always returning the hit?!? why?

2. Why TSQL does not return this hit? Again I tried w/100 instead of w/10 in TSQL.

Also please note that the actual record is
chief secretary's

(there is an apostrophe s in secreatary's)

thanks!!

Do you have suffix processing enabled? If not then secretary is a different word than secretary's. The error is because vortex does not process delimiters by default, as it causes a post-process step.