I can't get Dynamic List/Menu to work. I'm using JSP and MX. I am using Dreamweaver's Server Behavior which generates the code below (for a dynamic list of Personnel) but it always fails and I get a "Data Not Found" error on my server.
Anybody know what's wrong? This is just Dreamweaver generated code! I didn't hand code anything!
Help!
<select name="select">
<%
while (personnel_hasData) {
%>
<option value="<%=((personnel.getObject("PersonnelID")!=null)?personnel.getObject("PersonnelID"):"")%>" <%=(((personnel.getObject("PersonnelID")).toString().equals(("Allen").toString()))?"SELECTED":"")%> ><%=((personnel.getObject("LastName")!=null)?personnel.getObject("LastName"):"")%></option>
<%
personnel_hasData = personnel.next();
}
personnel.close();
personnel = Statementpersonnel.executeQuery();
personnel_hasData = personnel.next();
personnel_isEmpty = !personnel_hasData;
%>
</select>
Anybody know what's wrong? This is just Dreamweaver generated code! I didn't hand code anything!
Help!
<select name="select">
<%
while (personnel_hasData) {
%>
<option value="<%=((personnel.getObject("PersonnelID")!=null)?personnel.getObject("PersonnelID"):"")%>" <%=(((personnel.getObject("PersonnelID")).toString().equals(("Allen").toString()))?"SELECTED":"")%> ><%=((personnel.getObject("LastName")!=null)?personnel.getObject("LastName"):"")%></option>
<%
personnel_hasData = personnel.next();
}
personnel.close();
personnel = Statementpersonnel.executeQuery();
personnel_hasData = personnel.next();
personnel_isEmpty = !personnel_hasData;
%>
</select>