ESQL INSERT

[olivier demah]

from a form i get my data i want logically insert in my database so i 
did the following , but nothing comes in my blog_news table

<blog_addingnews>
   <xsp:logic>
   String id_blog_user = request.getParameter("id_blog_user");
   String id_blog_news = request.getParameter("id_blog_news");
   String news_title = request.getParameter("news_title");
   String news_text = request.getParameter("news_text");
   String news_image = request.getParameter("news_image");
   </xsp:logic>
   <id_blog_user><xsp-request:get-parameter 
name="id_blog_user"/></id_blog_user>
   <esql:connection>
       <esql:pool>mblog_pg</esql:pool>
       <esql:execute-query>
           <esql:query>
           INSERT INTO blog_news 
(id_blog_news,id_blog_user,news_title,news_text,news_image,news_date_creation,news_date_modify) 

           VALUES ('',<xsp:expr>id_blog_user</xsp:expr>,
           <xsp:expr>news_title</xsp:expr>,
           <xsp:expr>news_text</xsp:expr>,
           <xsp:expr>news_image</xsp:expr>,
           today,NULL);
           </esql:query>
           <esql:error-results>Database Error</esql:error-results>
           <esql:update-results>
               <esql:get-update-count/> Added
           </esql:update-results>
           <esql:no-results>
              <p>nothing done</p>
           </esql:no-results>
       </esql:execute-query>
   </esql:connection>
</blog_addingnews>
</xsp:page>
Regards.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]