An exception occured trying to convert String "dm_job_order Like " to type "java.lang.Double"
How can this code be fixed so it reads the '%' with the rest of the string?
Note: The % is a db2 database wildcard symbol.
Bear Bibeault wrote:OK, after picking myself up off the floor to see SQL syntax used in a JSP...
You are using a quote character within a string delimited by quote characters. How would you handle this if it were Java?
Bear Bibeault wrote:Interesting case you've got here. If the EL expression is outside the attribute value of the tag, the normal back-slash quoting works fine.
Apparently the triple-level of dual-purpose quoting when it's embedded inside a quoted attribute value adds a level of complexity to the parsing issue.
Rather than dither around trying to find the right combination of bizarre escaping that'd make this pass the parser, (at least for the moment) I'd set the string literal into a variable using <c:set>, and then use the variable in the expression.