Re: JDBC driver problem with sql LIMIT

2005-03-30 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 l'eau wrote: > > Using MySql Connect/J (mysql-connector-java-3.1.7.tar) > on Linux Fedora 2. > > I use a Statement object and do the following query: > > String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name > +"\') and

JDBC driver problem with sql LIMIT

2005-03-30 Thread l'eau
Using MySql Connect/J (mysql-connector-java-3.1.7.tar) on Linux Fedora 2. I use a Statement object and do the following query: String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name +"\') and term_type=\'"+ ontology +"\' LIMIT 20"; table term has 6 columns. MySql