Firstly, can I use prepared statements with access?
I'm trying to add a qualifier.
How do you backquote a " if you want the query
from this
ResultSet rs = stmt.executeQuery("select * from jobserve where location");
to
select * from jobserve where location like "*Amsterdam*"
I tried using a preparedstatement but it did not work.
The following returns zero rows.
PreparedStatement pstmt = con.prepareStatement("select * from jobserve where
location like ?");
pstmt.setString(1,"*London*");
If I just use "London" I don't get all those containing "London" just the
ones with "London" only.
...
Can you use preparedStatements with like qualifiers?
If not, how do you specify this via jdbc to access?
I've tried
ResultSet rs = stmt.executeQuery("select * from jobserve where location like
\"*London*\"");
and so forth.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
