Sybase Error Code = 404

[Subbisumi]

I'm using the Search Engine and I got this below error as it was using more than 250 AND's and OR's but I have to and can't help with that. I want to come out of this problem. Could you guys help me in solving this.

Thanks in Advance
Error Diagnostic Information
Sybase Error Code = 404

Too many ANDs or ORs in expression (limit 250 per expression level). Try splitting query or limiting ANDs and ORs.

Thanks,
Ganapa

 

[Tim1]

Hiya,

What on earth are you running that needs more than 250 ANDs and ORs? Is there no way that you can split this query into several queries? I cannot believe that your query is well optimized to use this complex a where clause.

There is no way round this limit, so you are going to have to managed your query a little different.

Tim