More query help

skalyanaraman · Post by **skalyanaraman** » Mon Apr 15, 2002 4:04 pm

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 ,

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!!

Post by **John** » Tue Apr 16, 2002 9:15 am

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.

skalyanaraman · Post by **skalyanaraman** » Tue Apr 16, 2002 1:33 pm

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!!

Post by **John** » Tue Apr 16, 2002 5:56 pm

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.