Bug 6434 - '%' interferes with <sql:query> expression
Summary: '%' interferes with <sql:query> expression
Status: RESOLVED WORKSFORME
Alias: None
Product: Taglibs
Classification: Unclassified
Component: DBTags Taglib (show other bugs)
Version: 1.0
Hardware: Other All
: P3 normal (vote)
Target Milestone: ---
Assignee: Tomcat Developers Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-02-13 19:20 UTC by Darrin Long
Modified: 2004-11-16 19:05 UTC (History)
0 users


Attachments
JSP showing that it works (1.77 KB, text/plain)
2004-02-27 14:03 UTC, Felipe Leme 		Details
Result of the test case (496 bytes, text/html)
2004-02-27 14:03 UTC, Felipe Leme 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Darrin Long 2002-02-13 19:20:52 UTC 
My JSP page stops output w/out throwing any exceptions when the following db 
tags are encountered:

<sql:query>
  SELECT * FROM addressBook WHERE projid LIKE '%dbTest%' 
</sql:query>

The last '%' in the expression '%dbTEst%' is what stops the jsp container from 
continuing its output. If I have the '%' in front w/out the '%' in the back 
everything is fine although that is not the expression I need. I need the 
last '%'. It seems to me there might be a conflict between the jsp '<%' 
reserved identifier and the last '%' in the expression. When I execute the 
statement in the phpAdmin MySql tool it works fine.
Comment 1 Morgan Delagrange 2002-04-15 04:05:38 UTC 
I tried to reproduce this in Tomcat 4.0 and MySQL, and could not.  I added 
a "like" test to the jdbc.jsp file in the dbtags-examples app to demonstrate 
this.

Which container exhibits this behaviour?
Comment 2 Felipe Leme 2004-02-27 14:03:37 UTC 
Created attachment 10587 [details]
JSP showing that it works
Comment 3 Felipe Leme 2004-02-27 14:03:56 UTC 
Created attachment 10588 [details]
Result of the test case
Comment 4 Felipe Leme 2004-02-27 14:04:59 UTC 
I second Morgan's comments - it is working (see attachments)