Hi,
I'm sure this is a forest for the trees problem, but I could use some
help here:
I have an outlet table in my database, and each outlet has a color.
Typically, an outlet has three colors, meaning three entries with the
same outlet name, different info and different color.
I am creating an 'Update/Edit' page that has a forTokens loop to edit all
three colors on the same page
<c:forTokens items="B,O,G" delims="," var="color">
that queries the database for that color and displays the information
about it
Problem:
I want to pass over this to another page that will take the
information and for the correct color, do an SQL update ie:
update outlet set blah where outlet='###' and color='RESPECTIVE COLOR'
- Since the 'select' tags all have the same name, I thought about using a
paramValues loop and iterate through each one, but I would need a seperate
array for colors and have it iterate each time, how do I do that in JSTL?
- I also thought about throwing the color into the select tag:
<input type="text" name="<c:out value ="${color}"/>switch" value="<c:out
value="${result.rows[0].switchip}"/>">
and doing the same on the other end, which did not work:
<sql:param value="${param.<c:out value="${color}"/>switch}"/>
Or is there some way that I'm too frazzled to see?
Thanks,
- Nic
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
