Report a bug of webgrid 7

yudi — Sun, 25 Dec 2011 21:14:18 GMT

Thank you for the valuable feedback.

This has been forwarded to WebGrid development team to be investigated further. I will keep you updated with any news I heard from the team regarding this matter.

Edited on December 27, 2011 4:23 AM
Reason: Add/update latest status

Both the * and % can be used interchangeably for wildcard characters in a LIKE comparison. If the string in a LIKE clause contains a * or %, those characters should be enclosed in brackets ([]). If a bracket is in the clause, each bracket character should be enclosed in brackets (for example [[] or []]). A wildcard is allowed at the start and end of a pattern, or at the end of a pattern, or at the start of a pattern. For example:

"ItemName LIKE '*product*'"
"ItemName LIKE '*product'"
"ItemName LIKE 'product*'"

Wildcard characters are not allowed in the middle of a string. For example, 'te*xt' is not allowed.

This should helps.

Report a bug of webgrid 7

rogerchen.tangshuo@gmail.com — Sat, 24 Dec 2011 08:28:32 GMT

input like "ab*cd" in filter bar to filter data, webgrid show error:

"Error in Like operator: the string pattern 'abcd%' is invalid.* "

http://live.intersoftpt.com/Default.aspx?path=/WebGrid/Data%20Filtering&url=cs/WebGrid/EnableFiltering.aspx can show this issue.

Intersoft Community - WebGrid Enterprise - Report a bug of webgrid 7

Report a bug of webgrid 7

Report a bug of webgrid 7

"Error in Like operator: the string pattern 'ab*cd%' is invalid. "

"Error in Like operator: the string pattern 'abcd%' is invalid.* "