"select table1.description as desc1, table2.description as desc2..." works in my rdbms Glenn
> -----Original Message----- > From: Richard Yee [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 26, 2001 4:29 PM > To: [EMAIL PROTECTED] > Subject: Re: Retrieve field value in JSP > > > Dick, > Instead of 'SELECT * FROM' use 'SELECT tablename.field1, > tablename.field2, > tablename.field3 FROM' in your query. field1..3 are the names of the > desired fields. You should pick up a book and learn how to > use SQL The > O'Reilly Java Enterprise in a Nutshell is a good reference book. > > Regards, > > Richard > > At 02:55 PM 9/26/01 +0800, you wrote: > >How ? > > > > > > > > Richard Yee > > <[EMAIL PROTECTED]> To: > > [EMAIL PROTECTED] > > Sent by: A cc: > > mailing list Subject: > Re: Retrieve > > field value in JSP > > about Java Server > > Pages > > specification and > > reference > > <JSP-INTEREST@JAV > > A.SUN.COM> > > > > > > 2001/09/26 01:22 > > PM > > Please respond to > > A mailing list > > about Java Server > > Pages > > specification and > > reference > > > > > > > > > > > >Dick, > >I think you answered your own question. I don't think you > can have two > >fields with the same name in the resultset. You should specify which > >description field you want returned in the query. > > > >-Richard > > > >At 01:13 PM 9/26/01 +0800, you wrote: > > >Dear all, > > > > > >select * from dick.joborder_details jd,dick.joborder_master > > >jm,dick.customer_master cm where jd.joborderno=jm.joborderno and > > >jm.customer_code=cm.customer_code > > > > > >There is two field called "description" in both table > "joborder_master" > >and > > >"joborder_details" but I cannot retrieve the jm.description or > > >jd.description ? why ? > > > > > > > > > <td > colspan="2"><%=result.getString("jm.description") %></td> > > >Why ??? It display the errors. > > > > > >Thanks for your help. > > > > > > > >============================================================= > ============== > > >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > >JSP-INTEREST". > > >For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST > >DIGEST". > > >Some relevant FAQs on JSP/Servlets can be found at: > > > > > > http://java.sun.com/products/jsp/faq.html > > > http://www.esperanto.org.nz/jsp/jspfaq.html > > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP > > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets > > > >============================================================= > ============== > >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > >JSP-INTEREST". > >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > >DIGEST". > >Some relevant FAQs on JSP/Servlets can be found at: > > > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.html > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets > > > >============================================================= > ============== > >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > >JSP-INTEREST". > >For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST DIGEST". > >Some relevant FAQs on JSP/Servlets can be found at: > > > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.html > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP > > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets > > ============================================================== > ============= > To unsubscribe: mailto [EMAIL PROTECTED] with body: > "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.html > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
