handling multiple values in result set

[lovinasd]

Hi,
i have a sql statment in the result set whose result is aan input to another sql statment.I am able to retreive one row but the next row is not retrieved the first result set is not getting executed..
eg.
rs=select distinct(name ) from sample;
this name is used in the next statment to retrive
rs2=select * from sample where name=name;
This execute the first row.
the nxt row there is a error in rs.next statment.
caould you tell me how can i retrivethe results from the resultset1
Do let me know
Thanks

 

[lhugh]

why can't you write a sql statement like this

SELECT * FROM sampe WHERE name IN (SELECT DISTINCT(name) FROM sample)

 

[quarryknight]

You should make sure you are using MYSQL 5.0 before attempting to use the IN operator. At least, I think it's 5.0. I don't believe the earlier versions support it.

Nick Ruiz

http://www.DealMerchant.net

Webmaster, DBA

 

[lhugh]

Good point.

Another way to do it is to create a class for the sample table

public class Sample {
private int field1;
private string field2;

some getter and setter

}

* Create an array, list of the type Sample

* iterate through your object with a while loop and

while (object.hasnext() ) <-- check syntax here
{
select * from sample where name = current value of the object

}

 

[stefanwagner]

The query should be equivalent to:

SELECT * FROM sample WHERE name is not null;

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung

 

[stefanwagner]

btw: how are you lead to the opinion, he uses mysql?

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung