Hi I have a set of jsp files that write to, and retrieve from, a MySQL database. I am using vectors to store the retrieved data rather than arrays as I do not know in advance how many data there are to be retrieved from the fields of the database.
Sometimes a field may contain a NULL value (listed in MySQL as "NULL"). When this happens, the jsp page gives me a null pointer exception for the Vector that is trying to retrieve from that particular field. For the database interface, it is not so important that there is a NULL value, so I am not too fussed about it. However, the jsp file is always giving the error. Is there a way of avoiding the error coming up when any given Vector contains a null value? That would cut down on the errors for the jsp pages tremendously. Thanks Hugo -- Dr Hugo Bouckaert Systems and Programming Engineer GeoInformatics Exploration Australia P/L 57 Havelock St West Perth, WA 6005 PO Box 1675, West Perth 6872 Ph: 61 08 9420 7400 Fax: 61 08 9226 1299 www.geoinformex.com ------------------------------------------------------------------------ This email and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
