Signup · Login
Stardeveloper.com  
Home · Tutorials · Forums · ASP.NET Newsletter Application · Web Hosting Plans · Faisal Khan's Blog · Contact
Forums : J2EE : JSP : Achor on on info in a JSP page Signup · Login
Author Thread
Achor on on info in a JSP page
Posted in tutorial: Accessing Database using Tags in JSP Pages
·  spartan
User
Joined: 26 Nov 2004
Total Posts: 3

Achor on on info in a JSP page

Posted: 26 Nov 2004
I hope my question will not sound stupid. Pardon me and kinldy give me a feed back.I want to get entered information from website directed to my JSP page. Then use it to make a select query. Passing this parameter to select sql query is a problem. Can you correct inside the code what you feel could not produce a run time error. where I have problem is(WHERE USERID = ' + request.getParameter("UserID") + '
). I am using Blazix Taglibrary

<html><body>
<blx:sqlConncetion jndiName ="guestbookodbc"
Int ID = request.getParameter("UserID")
<blx:sqlQuery Id="guestbook">
SELECT* FROM GUESTBOOK
WHERE USERID = ' + request.getParameter("UserID") + '
</blx:sqlQuery>
<table><
<blx:sqlExecuteQuery resultset = "rs" queryref="guestbook">
<tr><td><%=reqguest.getParameter("UserID")%></tr>
</table>
</blx:sqlExecuteQuery >
</blx:sqlConncetion >
<html><body>
Note: The UserID is an integer

Information is more than Gold
Want to leave a comment? Login or Register for free!

Users Who Have Visited This Thread In Last 24 Hours
2 Visitors

Login to post a comment or start a new thread
UserName Or Email Address:       Password:       Auto-Login:    
· Create New User Account
· Send Forgotten Password by Email
 
© 1999 - 2010 Stardeveloper.com, All Rights Reserved.