load pull down menu on JSP page

[jt]

I am new to Javascript and I am having problems with loading a pull
down menu.

I get this error:
javax.servlet.ServletException: No data found

It will list the items just fine if I just list the items without
using the select & option tags. I would like to know why I am getting
an error with the following statement:

<select size="1" name="org">
<% while (rs.next()) { %>
<option value="<%=rs.getString("ORG_CODE")%>">
<%=rs.getString("ORG_CODE")%>
</option>
<% } %>
</select>

Thank you.
-jptu

[mscir]

jt wrote:

I am new to Javascript and I am having problems with loading a pull
down menu.

I get this error:
javax.servlet.ServletException: No data found

It will list the items just fine if I just list the items without
using the select & option tags. I would like to know why I am getting
an error with the following statement:

<select size="1" name="org">
<% while (rs.next()) { %>
<option value="<%=rs.getString("ORG_CODE")%>">
<%=rs.getString("ORG_CODE")%>
</option>
<% } %>
</select>

Did you try:

<option value="<%=rs.getString('ORG_CODE')%>">

[phuong tu]

Yes, I've tried it and it didn't work.

thanks,
jptu

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[mscir]

phuong tu wrote:

Yes, I've tried it and it didn't work.

What's the url of the page, or post the relevant code here.

[Michael Winter]

On 7 Apr 2004 18:11:04 -0700, jt <ju**********@yahoo.com> wrote:

I am new to Javascript and I am having problems with loading a pull
down menu.
OK...
I get this error:
javax.servlet.ServletException: No data found

It will list the items just fine if I just list the items without
using the select & option tags. I would like to know why I am getting
an error with the following statement:

<select size="1" name="org">
<% while (rs.next()) { %>
<option value="<%=rs.getString("ORG_CODE")%>">
<%=rs.getString("ORG_CODE")%>
</option>
<% } %>
</select>

....but I don't see how this is related to JavaScript. You're problem is
with JSP.

You can find the JSP support forums at:

<URL:http://forum.java.sun.com/forum.jsp?forum=45>

Good luck,
Mike

--
Michael Winter
M.******@blueyonder.co.invalid (replace ".invalid" with ".uk" to reply)

[kaeli]

In article <6f*************************@posting.google.com> ,
ju**********@yahoo.com enlightened us with...

I am new to Javascript and I am having problems with loading a pull
down menu.

I get this error:
javax.servlet.ServletException: No data found
Probably because your query isn't returning any data, but something
expects it to.


It will list the items just fine if I just list the items without
using the select & option tags. I would like to know why I am getting
an error with the following statement:

<select size="1" name="org">
<% while (rs.next()) { %>
<option value="<%=rs.getString("ORG_CODE")%>">
<%=rs.getString("ORG_CODE")%>
</option>
<% } %>
</select>

You have no code here as to what to do if there is no rs.next() - that
is, if the query returns no rows. If it returns no rows, you get an
empty select element. That might be mucking up other code that assumes
there is data in the select element.
Add code that counts how many rows are returned, then check that and
throw an error or something to handle 0 rows.
--
--
~kaeli~
Dancing cheek-to-cheek is really a form of floor play.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

[phuong tu]

Thanks for all your inputs. Sorry, I should have posted this under
java. I found 2 tips to make it work.

1. I changed my select statement from "select * ..." to "select ORG_CODE
..."
2. I assigned the data pulled from recordset to a variable before
inserting it to the pull down.

here's the revised version:
<select size="1" name="org">
<%
String org = null;
while (rs.next())
{
org = rs.getString("ORG_CODE"); %>
<option value="<%=org%>">
<%=org%>
</option>
<%
} %>
</select>


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[kaeli]

In article <40*********************@news.frii.net>,
ju**********@yahoo.com enlightened us with...

Thanks for all your inputs. Sorry, I should have posted this under
java. I found 2 tips to make it work.

1. I changed my select statement from "select * ..." to "select ORG_CODE
.."
2. I assigned the data pulled from recordset to a variable before
inserting it to the pull down.

You might also want to do something special in case the org code is
null, if null values are allowed. Otherwise it just prints out the
string "null", which might not be what you want.
--
--
~kaeli~
The more ridiculous a belief system, the higher probability
of its success.
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace