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 ]