I'm searching custom tables using exactly the same script that is in Search.pm - just changing the name of the table from Links to the custom table.

I can't get substring to turn off in the custom tables. Does anyone have any idea why this might be? I'm starting to get complaints from my users so I'd really like to get this fixed asap.

For example:
http://www.theukhighstreet.com/...play&substring=1
http://www.theukhighstreet.com/...play&substring=0
These give different results
http://www.theukhighstreet.com/...play&substring=1
http://www.theukhighstreet.com/...play&substring=0
These give the same results

Both tables are using internal indexing.

Thanks,
Laura.
The UK High Street

Hi Laura,

It seems not a problem with my custom table. Substring can be turned off.

Long

Finally seem to have fixed it .

(Think it was a rogue line in my file that was imposing restrictions in some tables and not others. I put it inside an if statement so it was imposed only on those tables and that seemed to do it.)

I'm so happy to have fixed it as its been annoying me for months and I had thought it was something to do with my table not being indexed correctly or being corrupted.

glad to hear that you have worked it out.

Long