Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

retrieve records - 500 null help pl!

 
Sridhar Srinivasan
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!
I am having the foolowing code:
ArrayList hm411=(ArrayList)SelectBuilderBean.getAllAsSelect("scd",
"distinct department ","saestaff","where text1 like 'S%'","department","String");%>
<%
int h=0;
Iterator iter411 = hm411.iterator();
while (iter411.hasNext())
{
h=h+1;
%>
<%=((SelectValue)iter411.next()).getSelId()%>-<%=((SelectValue)iter411.next()).getSelName()%><br>

<%}%>
The above code gives 500 null error.Iam writing the query based on the parameters passed and adding the resultset to an object in the bean and I am retrieving it here.If I don't display either the SelId or the SelName(display only one), There is no error.Also if I remove "distinct" there is no error.Can anybody help pl!Thanks
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!