| Author |
Help
|
Amol Chavan
Greenhorn
Joined: Sep 04, 2005
Posts: 28
|
|
Dear Ranchers, I'm trying to access a javascript variable value in JSP form. I have a combo box which has some value. On selecting one of its value I run a query with that parameter via setting up that parameter using preparedstatemnet. But i don know how to access this value in JSP bcos its a javascript var. here is code: ---------- (?,?): one of question mark is loginid which i can access but another parameter is the one that I'm getting thru combo box --i.e.document.frmboids.otherboids.options[document.frmboids.otherboids.selectedIndex].value --------------------------------------- if (ie) msg7+='<select name="otherboids" size="1" onchange="return pgdropdnchk1(document.frmboids.otherboids.options[document.frmboids.otherboids.selectedIndex].value,document.frmboids)" style="font-size: 11px; font-family: Arial; color: Black;">'; var boid = document.frmboids.otherboids.options[document.frmboids.otherboids.selectedIndex]; alert("BOID: " +document.frmboids.otherboids.options[document.frmboids.otherboids.selectedIndex].value); <% sqlquery = "select * from the (select cast(vw.bo_init(?,?) as cdsl_admin.initial_tbl ) from dual)"; PreparedStatement preparedstatement1 = conn.prepareStatement(sqlquery); preparedstatement1.setString(1, userinfo.getLoginid()); preparedstatement1.setString(2, boid.value); rs = preparedstatement1.executeQuery(); while (rs.next()) { -------------------------------- plz help me.. Thanks, Amol  [ March 17, 2006: Message edited by: Bear Bibeault ]
|
Thanks n Regards,<br />Amol
|
 |
Kj Reddy
Ranch Hand
Joined: Sep 20, 2003
Posts: 1697
|
|
Duplicate of http://www.coderanch.com/t/289331/JSP/java/Help
|
 |
Bear Bibeault
Author and ninkuma
Marshal
Joined: Jan 10, 2002
Posts: 56529
|
|
|
read this
|
[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
|
 |
 |
|
|
subject: Help
|
|
|