Solved

Query statement

Posted on 2003-11-28
3
217 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
ID: 9841319
I think it should be select users.skill, ....
let me know if you have further enquires.
0
 

Author Comment

by:Jasbir21
ID: 9841367
it works, thank you so much,

thanks and God bless
0
 
LVL 14

Expert Comment

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

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Direct mail marketing is the act of mailing materials straight to prospective customers. This wide form of marketing is one of the oldest methods of communicating with a geographic based demographic. So is it useful in 2017 and beyond?
This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

679 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