Limit "WHERE condition" in Repeater with custom query

Vuthy Sok asked on December 12, 2016 04:02

Dear All,

Here my error message "The entered values cannot be saved. Please see the fields below for details. WHERE condition: Maximum allowed length of the input text is 500."

Here my WHERE Condition "(p.projectName LIKE '%{% SQLEscape(QueryString.GetValue("name", ""))#%}%' or p.projectName IS NULL) AND (p.theme LIKE '%{% SQLEscape(QueryString.GetValue("theme", ""))#%}%' or p.theme IS NULL) AND (p.keywords LIKE '%{% SQLEscape(QueryString.GetValue("keyword", ""))#%}%' or p.keyword IS NULL)"

My Character length just 292 Characters but i got error message when i try Save Webpart. I am not sure about "WHERE condition" work with multi condition query string.

Do you have any idea fix this issue?

Thanks

Correct Answer

Jan Hermann answered on December 12, 2016 09:23

There are macros in your where condition and the # sign hides the signature, so the actual length is much longer. Please increase the size of your where condition property.

0 votesVote for this answer Unmark Correct answer

   Please, sign in to be able to submit a new answer.