after upgrading to 8.1 from 7.9 i got a lot of syntax error would you please help me
The error looks like it is related to a different (albeit similar) query. I'd focus on this area of your error:
It looks like you're substituting a value into your query and generating a syntax error. That said, consider restructuring this to use a Named Query and proper parameterization to prevent SQL Injection (re: your Root Container.Filter Group.Filter.text
substitution).
Thanks for the reply, I want to know the root cause because I have a lot of this script in the 7.9 version that works fine, why is it not working on version 8.1
You haven't really provided enough information for us to tell you. If you want a formal answer, then you should formally contact Support, where employees have signed NDAs and can look at your system live and figure out what's going on.
Ok I will go support Thanks