Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > JSP Basics
|
JSP Basics Beginning-level questions on JSP. More advanced coders should post to Pro JSP.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the JSP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 2nd, 2004, 03:05 PM
Authorized User
 
Join Date: Jul 2004
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default call resultset in join query

I have a SQL query: SELECT * FROM Job_Request_Record, Requester_Record WHERE Job_Request_Record.Job_Requester_ID=Requester_Reco rd.Requester_ID; if i want to call an attribute from Job_Request_Record table e.g. rs.getString("ID")is it valid? or anything else. please help.

Also, is it possible to have a create view table in ms access 2003?


 
Old November 5th, 2004, 06:25 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default

What is your requirement?

You can refer at
http://java.sun.com/docs/books/tutor...ics/joins.html

for join query & resultSet

Gokulan Ethiraj
 
Old November 5th, 2004, 08:44 AM
Friend of Wrox
 
Join Date: Jul 2004
Posts: 204
Thanks: 0
Thanked 0 Times in 0 Posts
Default

As long as the column "ID" is returned to the record set you should be able to use rs.getString("ID")
As you are using a wildcard, i.e. SELECT * then you should be returning all columns.

As for the create table question, I am sure it is possible, but you would be better looking for SQL tutorials.






Similar Threads
Thread Thread Starter Forum Replies Last Post
JOIN query wverner Access 2 April 5th, 2005 01:44 PM
display the resultset of 2 table join keyvan Classic ASP Basics 0 March 9th, 2005 04:50 AM
display the resultset of 2 table join keyvan Classic ASP Databases 0 March 7th, 2005 09:34 AM
Join Query tsimsha Classic ASP Databases 2 December 2nd, 2004 09:31 AM
Query Tables -- Resultset Paul O. Schenker Excel VBA 1 July 16th, 2003 04:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.