Loop through an Array and invoke SQL command

[Robert_85]

Hi Guys,

I've got a big problem with these JSP/JSPX pages. I'm sure you people can help me.

Basically I am passing an array of strings from a Java servlet to a JSP page where I am trying to go through the array using 'forEach' loop and for each element, invoke a MYSQL command.

The array is called "Websites".

Here is my code:

<c:forEach var="e" begin="0" step="1" end=${Websites.length}>

<sql:query var="table">
select SUM(usability) as number from ${Websites[e]};
</sql:query>
.......

I have two main problems, firstly in the ForEach Tag, "Website.length" is not working, it returns SQL error at run time.
secondly in the MySql command, "${Website[e]}" is not working too, it returns SQL error at run time as well.

PLease Please help because I have been spending so much time on this.

[Tolls]

Posting exceptions might help.
I only ask because if Websites is simply an array there is no way it'll throw a SQLException in the for-each loop.

I would also suggest that you do the SQL in the servlet and simply pass all the necessary data into the JSP page. It's be a lot easier to debug, if nothing else. Data gathering sholdn't really be the responsibility of the JSP.

[Robert_85]

Thanks for reply, but Toll, your answer does not make sense to me (sorry i am not very good with jsp), this is my exact problem that I don't know whether my forEach loop is correct or not, that was actually my question, is my forEach loop correct?

[Tolls]

Well, the problem is you say it's throwing a SQL exception...which can't be the case from a for-each, unless Website is doing something odd.

Posting the exceptions helps us to understand your problem.