JDBC query Problem Using MS-Access

Greenhorn

Posts: 3

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Guys,
Kindly help in getting the query sorted. I want the names of the fields of the AREA, ENGINEER and PROBLEM,which I am unable to it.
Thakns In Advance!
Shekar

<html>
<head>
<title> Updating The Customer</title>
</head>
<%@ page language= "java" import="java.sql.*" %>

<h1>Updating DSLCustomer Status</h1>

<h4>Kindly Follow The Date And Time Attended As >12hrs = none :<12hrs =* : <24hrs = ** : <36hrs = *** and so on With The Completion Time</h4>
<table border="1" > <tr> <td>[B]Comp ID[/B]</td> <td>[B]Customer Faced[/B]</td> <td>[B]Phone[/B]</td> <td>[B]Date[/B]</td> <td>[B]Problem Faced[/B]</td> <td>[B]Time Of Complaint[/B]</td> <td>[B]Area[/B]</td> <td>[B]Engineer[/B]</td> <td>[B]Completion Time[/B]</td>  </tr> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc [img]http://www.javaranch.com/ubb/redface.gif[/img]dbc:ccare1"); Statement stmt = con.createStatement();  ResultSet rs = stmt.executeQuery("SELECT area.areaname, complaints.compid, complaints.custname, complaints.phoneno, complaints.doreg, complaints.intime, complaints.outtime, problem.problemname, engineer.engineername FROM problem INNER JOIN (engineer INNER JOIN (area INNER JOIN complaints ON area.areaname = complaints.area) ON engineer.engineername = complaints.engineer) ON problem.problemname = complaints.probem"); if(rs !=null)  {  while (rs.next())  { String comid = rs.getString("complaints.compid"); String client = rs.getString("complaints.custname"); String phone = rs.getString("complaints.phoneno"); String dreg = rs.getString("complaints.doreg"); String prob = rs.getString("problem.problemname"); String intim = rs.getString("complaints.intime"); String area = rs.getString("area.areaname"); String eng = rs.getString("engineer.engineername"); String outim = rs.getString("complaints.outtime");  %> <tr> <td><%= comid %></td> <td><%= client %></td> <td><%= phone %></td> <td><%= dreg %></td> <td><%= prob %></td> <td><%= intim %></td> <td><%= area %></td> <td><%= eng %></td> <td><%= outim %></td>  </tr> <% }       }       stmt.close();       con.close(); %> </table>
</body>
<html>

------------------------------------
tables :
complaints:
compid (int)custname,phoneno,doreg,intime,problem,area,engineer,outtime(alltext)
area : areaid, area(strings)
engineer : engid, engineer(text)

Peter den Haan

author

Posts: 3252

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

select a.area, e.engineer, c.problem
from complaints c, area a, engineer e
where a.areaid = c.area and e.engid = c.engineer
Is that wat you were looking for? Using "engineer" and "area" instead of "engid" and "areaid" in your complaints table is a bit confusing, by the way.
- Peter

So I left, I came home, and I ate some pie. And then I read this tiny ad:

Free, earth friendly heat - from the CodeRanch trailboss

https://www.kickstarter.com/projects/paulwheaton/free-heat