----- Original Message -----
From: Juraj Kazda <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 16, 2000 1:20 AM
Subject: Re: Access , JDBC-ODBC bridge and quoting.
> Hi Rob,
>
> this is not an PreparedStatement issue, it's a bad thing in MS ODBC driver
> (MS, as usual...:-) ). Just change the asterisk sign to percento sign:
>
> PreparedStatement pstmt = con.prepareStatement("select * from jobserve
> where location like ?");
> pstmt.setString(1,"%London%");
>
> Hope this helps.
>
> --jerry
>
> P.S.: I know that when you try to run such SQL command from within Access
> you should use '*', otherwise it will return zero rows, but in your code
> you should use '%'. It's another MS magic...
>
>
>
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Nicholson
> Sent: Friday, June 16, 2000 8:18 AM
> To: [EMAIL PROTECTED]
> Subject: Access , JDBC-ODBC bridge and quoting.
>
>
> 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
>
>
===========================================================================
> 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
===========================================================================
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
