Dan Cooperstock wrote:
> Mark Matthews wrote:
>
> > I'd be curious to know what vendors allow you
> to
> > use it to bind to a multi-value list for
> prepared
> > statement parameters, though (if any).
>
> I have no idea whether any vendors allow you to do
> this. It was my best guess as to how to bind a
> parameter to a "where column in (....)" clause in
> SQL, based on the rather sketchy API docs.
The JDBC apidocs basically assume you've read the SQL spec too ;)
The "JDBC API Tutorial and Reference, 2nd Edition" (book form is the only one I know of) is better from an JDBC API point-of-view for those that don't have the SQL standard sitting on their desk.
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html