I've had simmilar problems. I had something like this... String blah = myResultSet.getString("BLAHBLAH"); if(!myResultSet.wasNull()){ if(blah.equals("something)){ ...boom nullPointer exception
I'm not sure why the null value wasn't caught by wasNull(). Anyway I worked around it by adding an if(blah!=null){ before I used any string methods such as the equals(). Hope this helps. If anyone else can provide an explaination I would be grateful. --Aaron -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 3:43 PM To: Lalit Nagpal; [EMAIL PROTECTED] Subject: Re: why null being returned At 8:17 -0700 5/10/02, Lalit Nagpal wrote: >through a servlet i insert my form data into my table >(primary key is auto-incremented) and then i throw >another query which is >select last_insert_id() from mytable limit 1 >through my <statement>.executeQuery method. when i ask >for the data through ><myresultset>.getString(1) i get null >NullPointerException >why ... any ideas ... i welcome your suggestions >friends. > ># Lalit Nagpal # I don't know why you're getting a null pointer exception, but your second query should be just: SELECT LAST_INSERT_ID() And maybe you want to invoke getInt() instead of getString()? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php