Hi Everybody, I am trying to process web form and insert its values to the database using DBTags. This is what I am doing:
<%-- insert a row into the database --%> <sql:preparedStatement id="stmt1" conn="conn"> <sql:query> INSERT INTO CUSTOMER (CUST_PHONENO, CUST_NAME, CUST_SURNAME, CUST_TOWN, CUST_EMAIL, CUST_USERNAME, CUST_PASSWORD, CUST_WWW_REGISTERED_DATE, CUST_FK_CT_ID, CUST_FK_CS_ID) values (?,?,?,?,?,?,?,?,?,?) </sql:query> <sql:setColumn position="1">48<%= CustomerBean.getPhone_no()%></sql:setColumn> <sql:setColumn position="2"><%= CustomerBean.getName()%></sql:setColumn> <sql:setColumn position="3"><%= CustomerBean.getSurname()%></sql:setColumn> <sql:setColumn position="4"><%= CustomerBean.getTown()%></sql:setColumn> <sql:setColumn position="5"><%= CustomerBean.getEmail()%></sql:setColumn> <sql:setColumn position="6"><%= CustomerBean.getLogin()%></sql:setColumn> <sql:setColumn position="7"><%= CustomerBean.getPasswd()%></sql:setColumn> <sql:setColumn position="8"><%= sqlDateTimeFormat_.format(Callendar_.getTime()) %> </sql:setColumn> <sql:setColumn position="9">WWW</sql:setColumn> <sql:setColumn position="10">ACTIVE</sql:setColumn> <sql:execute/> </sql:preparedStatement> I have one problem: 3 fileds in the formcould be emtand I would like to live these database fields set as NULL, How can I do it? Is it possible to insert NULL value using "preparedStatement" tag ? thank you for your help. regards, lukas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]