Solved

Query statement

Posted on 2003-11-28
3
211 Views
Last Modified: 2010-04-01
.. i have a query statement like this:
String query2="Select users.username,userskills.username from users,userskills where users.username=userskills.username and  users.username='"+vol.getUsername()+"'";


rs3=stmt2.executeQuery(query2);


My problem is i try to see output :
<%
if(rs3.next()){
while(rs3.next()){
%>
Skill:<%=rs3.getString("users.skill")%>
}
}%>

but i couldn't see , di d i do something?

Thanks
0
Comment
Question by:Jasbir21
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
kennethxu earned 65 total points
Comment Utility
I think it should be select users.skill, ....
let me know if you have further enquires.
0
 

Author Comment

by:Jasbir21
Comment Utility
it works, thank you so much,

thanks and God bless
0
 
LVL 14

Expert Comment

by:kennethxu
Comment Utility
i'm afraid that I'm getting points too easy :-)
let me know if you have further enquires.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now