want to retrive more than one table
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   mubbashshir_mubbashshir
Posted On:   Thursday, March 29, 2001 09:02 PM

I have stored the names of my table in
a array with name Table_Of_Search
and using it select * for Table_Of_Search but the problem is that
it is not retriving and giving
37000 and some times os800 can you
help me out

Re: want to retrive more than one table

Posted By:   Anonymous  
Posted On:   Friday, March 30, 2001 02:22 PM

As far as I could undertand from your question is that you are trying to do something like this



String[] tables = ("yourTableOne", "YourTableTwo");
String query = null;
ResultSet rs = null;
...
//Inside your method
query = "select * from "+tables[0];
//stmt is the object of Statement
rs = stmt.executeQuery(query);
... //some processing on rs
query = "select * from "+tables[1];
//stmt is the object of Statement
rs = stmt.executeQuery(query);

If this is not what you are looking for then please elaborate your question and also embed your code in your question. That will help.


regards


Yasir
About | Sitemap | Contact