Thank you,Justin. If you tried to run MySQL on Windows NT? The problem with the JDBC_ODBC bridge than when you select from 2 tables (like join) then getTableName gives you empty string. So you have to select at first from first table and then from the second one. Elena >From: Justin Wood <[EMAIL PROTECTED]> >Reply-To: Orion-Interest <[EMAIL PROTECTED]> >To: Orion-Interest <[EMAIL PROTECTED]> >Subject: RE: mySQL >Date: Wed, 26 Sep 2001 12:15:06 +0200 > >If you have to rely on how many columns a query returns it is very likely >that your database is not properly normalised so look there first. > >It could be that ODBC does not support the number of columns metadata but I >am not sure. Your problems should be solved with your move to mySQL; I >recall having used that method on mySQL JDBC with success in the past. > >Justin > >-----Original Message----- >From: Emeline Barns [mailto:[EMAIL PROTECTED]] >Sent: 22 September 2001 08:10 >To: Orion-Interest >Subject: Re: mySQL > > >Hi Ray, >Thank you very much for your help. Yes, I amusing jdbc-odbc bridge, but I >am > >not sure if put on shared drive it canhold 25 simaltenous connection >without > >crashing. >Besides, when I am selecting data from first table using >String sqlStatement = "Select * from " + first_table+ "," +second_table + " >where " + filed_name + " Like '%" + keyword + "%'"; >and what to know number of columns selected >col_number = rsmd.getColumnCount(); >it gives me number of columns from 2 tables.When I want to find to which >table this column belongs >table_name = rsmd.getTableName(1); >it gives me empty String. >So still do not know how to find the real number of columns selected. >Elena > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp