Henner, I understand the problem with the null pointer. but in reality the two searches are both valid and should return one row each time. I believe this is caused by the firstpos parameter being set to "3" when "3" is searched, then when "1" is searched, no records are found because the firstpos is still "3". the following works with /testsuite/priority_viewTable.jsp with filter on:

1. search priority 1, then apply ... no problems (1 displayed)
2. search priority 3, then apply ... no problems (3 displayed)
3. search priority 1, then apply ... "java.lang.NullPointerException" (ie no record found) (i would have liked 1 to be displayed)

I have found this situation also occurs when sorting is performed. again with /testsuite/priority_viewTable.jsp
1. sort ascending, rows 1-3 displayed
2. sort descending, row 1 displayed only

I assume this is also caused by the firstpos parameter.

Should the firstpos & lastpos always be set to null and not used when performing searching and sorting?

regards,
Ben

----Original Message Follows----
From: "Henner Kollmann" <[EMAIL PROTECTED]>
To: "'Ben Heath'" <[EMAIL PROTECTED]>
CC: "dbf" <[EMAIL PROTECTED]>
Subject: AW: [dbforms] Search/Filter problems
Date: Wed, 12 Feb 2003 08:41:42 +0100

Hi Ben,

>
>
> I am trying to use filtering/searching on the testsuite and
> always get a
> "java.lang.NullPointerException" when searching for the
> second time and the
> second search is less than the first.
>
> eg. on /testsuite/priority_viewTable.jsp with filter on
>
> 1. search priority 3, then apply ... no problems
> 2. search priority 1, then apply ... "java.lang.NullPointerException"
>

Just tested.

You get the NullPointerException if the resultset you search for gives
no data. This is by design of the jsp. There the expression
currentRow_priority.get("id") is used. This will raise the exception if
there are no data (currentRow = null).

Hope that helps,
Henner


_________________________________________________________________
MSN Instant Messenger now available on Australian mobile phones.�Go to http://ninemsn.com.au/mobilecentral/hotmail_messenger.asp



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
DbForms Mailing List

http://www.wap-force.net/dbforms

Reply via email to