Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Query statement

Posted on 2003-11-28
3
Medium Priority
?
229 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 260 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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

The article explains the process to deploy a Self-Service password reset portal I developed a few years ago. Hopefully, it will prove useful to someone.  Any comments, bug reports etc. are welcome...
How do you create a user-centered user experience on your website? And what are some things you should consider in the process?
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

578 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