Return-Path: 
 <users-return-60552-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 2686 invoked from network); 3 Jan 2004 19:44:46 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 3 Jan 2004 19:44:46 -0000
Received: (qmail 71301 invoked by uid 500); 3 Jan 2004 19:44:28 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 71120 invoked by uid 500); 3 Jan 2004 19:44:27 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
list-post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 71103 invoked from network); 3 Jan 2004 19:44:27 -0000
Received: from unknown (HELO main.gmane.org) (80.91.224.249)
  by daedalus.apache.org with SMTP; 3 Jan 2004 19:44:27 -0000
Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian))
	id 1AcrhH-0006x1-00
	for <users@cocoon.apache.org>; Sat, 03 Jan 2004 20:44:31 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: users@cocoon.apache.org
Received: from sea.gmane.org ([80.91.224.252])
	by main.gmane.org with esmtp (Exim 3.35 #1 (Debian))
	id 1AcrhG-0006wt-00
	for <gmane-text-xml-cocoon-user@m.gmane.org>; Sat, 03 Jan 2004 20:44:30 +0100
Received: from news by sea.gmane.org with local (Exim 3.35 #1 (Debian))
	id 1AcrhG-0006ox-00
	for <gmane-text-xml-cocoon-user@m.gmane.org>; Sat, 03 Jan 2004 20:44:30 +0100
From: Jorg Heymans <jh@domek.be>
Subject: Re: Problems with date and xsp
Date: Sat, 03 Jan 2004 20:44:48 +0100
Lines: 54
Message-ID: <bt762t$pdi$1@sea.gmane.org>
References: <20031220211905.1a974235.ruf10@op.pl> <3FE4B2A8.1050705@domek.be>
 <20031220215213.2118a539.ruf10@op.pl> <3FE4C2ED.8040309@domek.be>
 <20031220231339.0eac5e60.ruf10@op.pl> <3FE4D361.6010209@domek.be>
 <20031221004235.40b5ad45.ruf10@op.pl> <3FE5839C.7080706@domek.be>
 <20031221135603.6a38ad49.ruf10@op.pl> <3FE5AC35.9050709@domek.be>
 <20031221160027.51268d23.ruf10@op.pl> <3FF6B067.1020600@gmx.de>
 <bt6v58$efn$1@sea.gmane.org> <20040103190025.0bd7ceb4.ruf10@op.pl>
 <bt71fm$hv2$1@sea.gmane.org> <6.0.0.22.2.20040103202320.01b51330@box.tin.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@sea.gmane.org
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.6b) Gecko/20031205 Thunderbird/0.4
X-Accept-Language: en-us, en
In-Reply-To: <6.0.0.22.2.20040103202320.01b51330@box.tin.it>
Sender: news <news@sea.gmane.org>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Could you *please* stop posting your problem in other threads? All it 
takes is to write a new mail instead of hitting reply+erase subject.

Davide wrote:

> Hi, i have some problems in getting the actual timestamp to put it into 
> a db.
> 
> My xsp is:
> 
> <?xml version="1.0"?>
> 
> <xsp:page language="java"
>     xmlns:xsp="http://apache.org/xsp"
>     xmlns:xsp-request="http://apache.org/xsp/request/2.0"
>     xmlns:xsp-session-fw="http://apache.org/xsp/session-fw/1.0"
>     xmlns:esql="http://apache.org/cocoon/SQL/v2">
>     <xsp:logic>
>         java.util.Date now=new java.util.Date();
>     </xsp:logic>
> 
>     <addcomment>
>         <page-title>Add a comment</page-title>
>         <!-- header bar background source file -->
>         <bg>images/logobg.gif</bg>
>         <!-- mcnavigator css -->
>         <css>css/main.css</css>
>         <esql:connection>
>             <esql:pool>mcnavigator</esql:pool>
>             <esql:execute-query>
>                 <esql:query>Insert into comments (User_ID, Comment_text, 
> Commented_URL, Comment_Date, Comment_browser) values (
>                     '<xsp-session-fw:getxml context="authentication" 
> path="/authentication/ID"/>',
>                     '<xsp-request:get-parameter name="comment_text"/>',
>                     '<xsp-request:get-parameter name="link"/>',
>                     '<xsp:expr>new 
> java.sql.Timestamp(now.getTime())</xsp:expr>',
>                     '<xsp-request:get-header name="user-agent"/>')
>                 </esql:query>
>                 <esql:error-results>An error occurred</esql:error-results>
>                 <esql:update-results>
>                     <message>Your comment has ben added; you can now 
> close this window</message>
>                 </esql:update-results>
>             </esql:execute-query>
>         </esql:connection>
>     </addcomment>
> </xsp:page>
> 
> The problem is that every time i add a new record to the db using this 
> xsp i notice that the time doesn't change. Any solution??
> 
> Best Regards, Davide


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org