SQL related problem

[wwworg]

HEY GUYS

I am running a select statement. Here it is

String query = "SELECT UNITNO, UNITNAME FROM Deprartment WHERE DeptID ='" + dept + "'";
db.executeSelectQuery(query);
return db.getActionResult();

now db.getActionResult() returns a 2-dimensional String array. What I want to understand is how to use this 2-dimensional array. I mean lets say that the 2-dimensional array is called str and lets say that the select returns 2 records, what would be str[1][0]?? or what would be str[1][1]??

Thanks for your help

 

[sedj]

I have no idea. It COMPLETELY depends on how you are filling the 2D array. Do you understand what a 2D array actually is ?

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[Diancecht]

Each row is a record, first column is UNITNO, second is UNITNAME.

Cheers,
Dian

 

[wwworg]

thanks guys