The SELECT is in a servlet, something like this:

rs = stmt.executeQuery("SELECT * FROM " + request.getParameter("table1") +
", " + request.getParameter("table2"));
session.setAttribute("result", rs);

that's a simplification of what it does, but it's good enough for
demonstration I think.

The .jsp file that calls the servlet knows what tables it wants to read out
of, and the .jsp file that the servlet redirects to knows what columns it
wants.  The servlet doesn't know anything and hopefully shouldn't care.  I
wanted to abstract it as much as possible.

sorry for the confusion and thanks for the help.


-----Original Message-----

From: Rene Pijlman

To: Ben Carterette


Sent: 8/20/01 12:28 PM

Subject: Re: [JDBC] select on multiple tables

On Thu, 16 Aug 2001 10:02:27 -0500, you wrote:

>This won't work because I don't know in advance of the SELECT which 

>tables I'm going to be selecting from.  

I'm not sure if I understand this correctly. Whenever you write

the SELECT statement you have to know the names of the tables,

that's required by the syntax of select.

What you're telling us is that you don't know the column names

when you construct the statement, but you do know the column

names 5 lines down when you want to do the rs.getString()?

>On Wednesday, August 15, 2001, at 06:29  PM, Rene Pijlman wrote:

>> On Wed, 15 Aug 2001 16:43:31 -0500, Ben Carterette wrote:

>>> I have a query like "SELECT * FROM table1, table2" and I want to


>>> values

>>> out of a ResultSet.  What if the two tables have column names in 

>>> common and

>>> I can't predict the column numbers?  Is there any way to get 

>>> and

>>>  rs.getString tells me "The column name not 

>>> found."


>> Does this also happen when you explicitly name the columns?


>>    SELECT, ...,, ...

>>    FROM table1, table2


>> Or if that doesn't help, try if a column label with the AS

>> clause works:


>> SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]

>>     * | expression [ AS output_name ] [, ...]



>>   SELECT AS id1, ..., AS id2

>>   FROM table1, table2


>> And then rs.getString("id1");


>> I think both solutions should work. Please let us know if they

>> don't.


>> Regards,

>> René Pijlman



>---------------------------(end of


>TIP 4: Don't 'kill -9' the postmaster


René Pijlman

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to