Unfortunately id doesn't return A.c and B.c. Try it in psql...

One way to solve this is to fix the backend to return fully qualified
column names.


-----Original Message-----
[mailto:[EMAIL PROTECTED]] On Behalf Of Rene Pijlman
Sent: August 20, 2001 3:49 PM
To: Carterette, Ben
Subject: Re: [JDBC] select on multiple tables

On Mon, 20 Aug 2001 12:50:22 -0500, you wrote:
>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.

How about using ResultSetMetaData.getColumnName() on the ResultSet to
dynamically query the column names? See:

I don't know that this will (and should) return when you do SELECT *
from A, B and there is a column c in both tables. Hopefully it returns
A.c and B.c.

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to