If you are using a recent implementation of the Servlet specification, you should use Apache's implementation of the JSTL, not DBTags. DBTags has been inactive since development on JSTL began, and it should be considered deprecated for Servlet 2.3 or 2.4 containers.
- Morgan Delagrange --- "PAZDZIOREK,LUKASZ (HP-Poland,ex1)" <[EMAIL PROTECTED]> wrote: > 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] > ===== Morgan Delagrange http://jakarta.apache.org/commons http://axion.tigris.org __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
