Bug 6434 - '%' interferes with <sql:query> expression
Summary: '%' interferes with <sql:query> expression
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
Depends on:
Reported: 2002-02-13 19:20 UTC by Darrin Long
Modified: 2004-11-16 19:05 UTC (History)
0 users

JSP showing that it works (1.77 KB, text/plain)
2004-02-27 14:03 UTC, Felipe Leme
Result of the test case (496 bytes, text/html)
2004-02-27 14:03 UTC, Felipe Leme

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:

  SELECT * FROM addressBook WHERE projid LIKE '%dbTest%' 

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 

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)