Search:

I still get the following error when the user input field is left blank:



Is there anything wrong in my if statement?



thanks

Thanks copeg, Can you give an example? as try to solve it by:



it doesn't work. thanks

thanks for the link, but my error is till not solve. After reading, "NumberFormatException - if the string does not contain a parsable integer." because the user input is left blank.

Any more...

Hi there,

Anyone knows how to solve this error, it only happens when I leave the user input field blank.

How to dynamically display the same search form for two different fields like "reg and speed" as it is for "number" below:

Hi there,

I would like to add a button called "more" next to "press me" button to dynamically duplicate the same search form for two different fields like "reg and speed" as it is for "number"...

Hi Kevin,

It seems that you found the NullPointerException as it does not appear in the stack trace anymore but my page is still no showing the result of the search.

As usual, I just see the...

Hi kevin,
it is indeed not very pleasant at the moment.



I am aware of it and i have the exact number of column, in my actual code they are all selected :).



Reading the Stack Trace,...

Hi Kevin



I got the following:

java.lang.NullPointerException
SQL statement is not executed!

Hi Kevin,

I get the following print out, does that tell you anything apart from "SQL statement is not executed" ?

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type...

Hi Kevin,

You are just confirming what I have mentioned earlier, I know the problem is with my sql statement.
I need a solution to my problem not theory around the problem.

I appreciate your...

"Where is your statement object for example. It might be worth you printing out your sql statement to the screen, just before you call executeQuery on your statement object, so you can see it. "
...

connected via jdbc and i can display the entire table but my problems is displaying the filtering of the search form!!!!

Hi Dear,
I need help with my code, I have built a search form based on comparison logic drop down list "greater than, less than and equal" and user input text field where you can enter a number...