hi frnds,
i have a form,which has 2 input text boxes, the values are entering the text boxes,when i leave the 2 text boxes blank and hit submit a java script gives the message that the 2 fields are blank.....the problem now is when i leave the text boxes blank the message appears...and when i click ok...then instead of showing me the page its giving me an exception-->
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Incorrect integer value: '' for column 'Publicity_Code' at row 1
org.apache.struts.action.RequestProcessor.processE xception(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(Actio nServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet .java:690)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)


root cause

java.sql.SQLException: Incorrect integer value: '' for column 'Publicity_Code' at row 1
com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:946)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2985)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 31)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1723)
com.mysql.jdbc.Connection.execSQL(Connection.java: 3256)
com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1313)
com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1585)
com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1500)
com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1485)
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStat ement.executeUpdate(DelegatingPreparedStatement.ja va:101)
publicity.BdgtMastAction.execute(BdgtMastAction.ja va:57)
org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(Actio nServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet .java:690)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
--------------------------------------------------------------------------------

Apache Tomcat

y is this happening??
im using struts tags-->

Code:
<html:submit value="Submit" property="thesubmit" onclick="everything(form)">&nbsp;</html:submit>
but when i do it using normal html tags its working perfectly alright--->

Code:
<input type="button" name="thesubmit" value="Submit" onclick="everything(form)">&nbsp;
can somebdy plz help me???
regards,
a_jos