Invalid SQL query in property "wherecondition".

I am using custom macro in where condition in repeater with custom query web part like this

(ClassName = 'myclass.name') and {%GetSomething())%}

Getsomething() macro is creating another half of the SQL query which brings a string like this

(Subject = 'Math' or Subject = 'Science')

When I run this query in SQL it works fine but on page it gives me

Invalid SQL query in property "wherecondition".

What I am missing ?

This syntax is incorrect:

(ClassName = 'myclass.name') and {%GetSomething())%}

You have an extra closing ) you need to remove before the closing macro.

Secondly, you may have to suffix your clause with a macro parameter:

(ClassName = 'myclass.name') and {%GetSomething()|(handlesqlinjection)false%}

because it may automatically try to SQL escape the value you're adding.

0 votesVote for this answer Unmark Correct answer