Kuldeepchaturvedi:Suggestion using javascript for pop-up_HELP

Hi,
  I liked the idea of using javascript for the colorid question. How do you do that? I found out that using skill.jsp takes a long time
<html>
<body>
<form action=color.jsp>

<%
String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=;password=";
Connection connection = null;

ResultSet rs = null;
try
{

 
   Class.forName("com.mysql.jdbc.Driver").newInstance();
  connection = DriverManager.getConnection(connectionURL, "", "");
 
 


}//try
catch( SQLException ex )
{
  ex.printStackTrace() ;
}
catch( ClassNotFoundException ex )
{
  ex.printStackTrace() ;
}

%>


<%
String my="select id,desc from color";
Statement stmt=connection.createStatement();
ResultSet rs2=stmt.executeQuery(my);
%>


Existing Skills :  

<select name="ChooseSkill"
>

<%
while(rs2.next()){ %>

<option value=<%=rs2.getString(1).trim()%>><%=rs2.getString(1).trim()%></option>
<%}%>
</select>


<a href="javascript:dothis();">Desc</a>


</p>

<input type="submit" value="Submit">
</form>
</body>
</html>



How do i assign the desc value to the javascript variable



Thanks

Jasbir21Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

apparitionCommented:
<script>

</script>
0
apparitionCommented:
oops...
<script>
     var x =<%=rs2.getString(1).trim()%>
</script>
0
Jasbir21Author Commented:
Hi,
  How do i display it in javascript that in javascript?
0
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Jasbir21Author Commented:
I mean, how do i tell or make a javascript function that says if this userid display the description

Thanks
0
apparitionCommented:
Question Title: Kuldeepchaturvedi:Suggestion using javascript for pop-up_HELP
Author: Jasbir21
Points: 200
Date: 10/29/2003 05:22AM PST
 


Hi,
  I liked the idea of using javascript for the colorid question. How do you do that? I found out that using skill.jsp takes a long time
<html>
<script>
  var colorDesc = new Array ()
      
   function  displayDesc(index) {
          alert (colorDesc[index])
   }
</script>
<body>
<form action=color.jsp name="color">

<%
String connectionURL = "jdbc:mysql://localhost:3306/mydatabase?user=;password=";
Connection connection = null;

ResultSet rs = null;
try
{

 
   Class.forName("com.mysql.jdbc.Driver").newInstance();
  connection = DriverManager.getConnection(connectionURL, "", "");
 
 


}//try
catch( SQLException ex )
{
  ex.printStackTrace() ;
}
catch( ClassNotFoundException ex )
{
  ex.printStackTrace() ;
}

%>


<%
String my="select id,desc from color";
Statement stmt=connection.createStatement();
ResultSet rs2=stmt.executeQuery(my);
%>


Existing Skills :  

<select name="ChooseSkill"
>

<%
int x = 0
while(rs2.next()){
%>
<script>
  colorDesc[<%=x>] = "<%=rs2.getString(2).trim()%>"
</script>
<option value=<%=x%>><%=rs2.getString(1).trim()%></option>
<%
x ++;
}%>
</select>


<a href="#" onclick="displayDesc(document.color.value.ChooseSkill);return false;">Desc</a>


</p>

<input type="submit" value="Submit">
</form>
</body>
</html>
 
 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jasbir21Author Commented:
hi,

 The error i got is

:org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 59 in the jsp file: /jsp2/col.jsp

Generated servlet error:
    [javac] Compiling 1 source file

C:\apache\tomcat\work\Catalina\localhost\jsp-examples\org\apache\jsp\jsp2\col_jsp.java:87: illegal start of expression
      out.print(x>] = "<%=rs2.getString(2).trim());
                  ^



An error occurred at line: 59 in the jsp file: /jsp2/col.jsp

Generated servlet error:
C:\apache\tomcat\work\Catalina\localhost\jsp-examples\org\apache\jsp\jsp2\col_jsp.java:87: unclosed string literal
      out.print(x>] = "<%=rs2.getString(2).trim());
                      ^



An error occurred at line: 59 in the jsp file: /jsp2/col.jsp

Generated servlet error:
C:\apache\tomcat\work\Catalina\localhost\jsp-examples\org\apache\jsp\jsp2\col_jsp.java:88: ')' expected
      out.write("\"\r\n");
                         ^
3 errors


      org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:128)
      org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
      org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:413)
      org.apache.jasper.compiler.Compiler.compile(Compiler.java:453)
      org.apache.jasper.compiler.Compiler.compile(Compiler.java:437)
      org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:555)
      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:856)


note The full stack trace of the root cause is available in the Tomcat logs.


Thanks
0
Jasbir21Author Commented:
Hi,
  I found the error, needed to %>

But now when i run it, i get document.color.value is not an object.

Could you pls help?
0
Jasbir21Author Commented:
Hi,
  I changed this :
(document.color.value.ChooseSkill) to

document.value.color.ChooseSkill

and it worked thanks.

When the window pops up, it goes in the middle,
is there anywhere to make it near the desc button.

Thanks



0
KuldeepchaturvediCommented:
So I see you got the answer before I ever got a chance to have a look at it...:-)
as far as your last wish of making it appear near desc button goes... than you will  have to use a popup window instead of alert...
something like this...
>>>>>
 function  displayDesc(index) {
         alert (colorDesc[index])
  }

will change to
>>>>>>
function displayDesc(index)
{
var oPopup = window.createPopup();
var oPopupBody = oPopup.document.body;
      oPopupBody.style.backgroundColor = "lightyellow";
      oPopupBody.style.border = "solid black 1px";    
    oPopupBody.innerHTML = colorDesc[index];
    oPopup.show(100, 100, 200, 50, document.body);}
}

now these co-ordinates (100,100,200,50) can be changed to your own liking...

Hope this helps.
Regards
0
Jasbir21Author Commented:

Hi,
   I was really looking for thant , thanks, when i tried to run it, i had a runtime error that says:
Object doesn't support this property or method and when try to debug it i had the debugger stop at:
var oPopup = window.createPopup();

What do i do?
0
KuldeepchaturvediCommented:
createpopup is supported only IE 5.5 and above, so make sure your browser is IE5.5 or above otherwise I am afraid it will not be working...
If it is ie 5.5 then it should be working....
0
Jasbir21Author Commented:
ok, thanks
0
Jasbir21Author Commented:
I have upgraded the browser and its working fine...
..Thanks again
0
KuldeepchaturvediCommented:
glad to be of help....:-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
JSP

From novice to tech pro — start learning today.