You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Ambaris Mohanty <am...@lifestylestores.com> on 2007/06/05 11:46:03 UTC

using jstl sql tags for displaying date from database

Hi all,

In my web application I want to put current date into the header segment of
each page. And I want that the date should come from the database. How can I
achieve this using jstl 1.1 sql tags. Can anybody provide me a code snippet
that I can put in my jsp page?

Thank you.


RE: using jstl sql tags for displaying date from database

Posted by Al Sutton <al...@al-and-andrea.org.uk>.
I still don't understand why you're not using the server to get the date and
explicitly including it in the query, for example;

<jsp:useBean id="now" class="java.util.Date" /> 
<sql:query var="books" >
  select * from table where date <= ?
  <sql:param value="${now}" />
</sql:query> 

Or even doing all of the above in an action and using the jsp to display the
results.

Using the database as a timesource is something 99.9% of developers advise
strongly against, isn't very well supported, and just isn't what a database
is designed to do, hence why there is very little support for it.


-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com] 
Sent: 05 June 2007 13:19
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Ok thanks for your reply n showing me the way. It seems you didn't get my
question write. Let me explain it to you...
When I query the database normally using <sql:query/> tag I get a result set
consisting of multiple rows, which I can display using using the
<c:forEach/> tag. But how to handle query like "select sysdate from dual"?
The whole application is based upon struts framework. I have used struts
1.2.9. I thought jstl sql tag would be a better option to execute such small
query since it's very simple. So, I'm trying to get it done using jstl. Can
u help?
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 5:20 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I'm showing you the solution, but I'm not going to do your job for you.

Now if you think about the question, that about how you would cope with
adjusting the time on one server (the web server) by a fixed offset (if the
database server is in another timezone), you'll see how you can do it
without hitting your network and the database for each occasion where you
want to get the time for a query.

I've got no reason to waste your time, having seen your entirely flash
website I can see why you need to do something about it.

(sheesh, this reminds me of having to deal with students when I worked at a
university).

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:47
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Do u have the solution or just wasting my time???

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 5:09 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason these aren't synchronized using NTP or a similar protocol
would be.......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:33
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Because the application is all about generating reports from the data in the
database. So I want to display the database server time and not the web
server time. It makes more sense to the users.
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 4:54 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason for not using the server time would be......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:21
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com]
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


RE: using jstl sql tags for displaying date from database

Posted by Ambaris Mohanty <am...@lifestylestores.com>.
Ok thanks for your reply n showing me the way. It seems you didn't get my
question write. Let me explain it to you...
When I query the database normally using <sql:query/> tag I get a result set
consisting of multiple rows, which I can display using using the
<c:forEach/> tag. But how to handle query like "select sysdate from dual"?
The whole application is based upon struts framework. I have used struts
1.2.9. I thought jstl sql tag would be a better option to execute such small
query since it's very simple. So, I'm trying to get it done using jstl. Can
u help?
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk] 
Sent: Tuesday, June 05, 2007 5:20 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I'm showing you the solution, but I'm not going to do your job for you.

Now if you think about the question, that about how you would cope with
adjusting the time on one server (the web server) by a fixed offset (if the
database server is in another timezone), you'll see how you can do it
without hitting your network and the database for each occasion where you
want to get the time for a query.

I've got no reason to waste your time, having seen your entirely flash
website I can see why you need to do something about it.

(sheesh, this reminds me of having to deal with students when I worked at a
university).

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com] 
Sent: 05 June 2007 12:47
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Do u have the solution or just wasting my time???

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 5:09 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason these aren't synchronized using NTP or a similar protocol
would be.......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:33
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Because the application is all about generating reports from the data in the
database. So I want to display the database server time and not the web
server time. It makes more sense to the users.
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 4:54 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason for not using the server time would be......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:21
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com]
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


RE: using jstl sql tags for displaying date from database

Posted by Al Sutton <al...@al-and-andrea.org.uk>.
I'm showing you the solution, but I'm not going to do your job for you.

Now if you think about the question, that about how you would cope with
adjusting the time on one server (the web server) by a fixed offset (if the
database server is in another timezone), you'll see how you can do it
without hitting your network and the database for each occasion where you
want to get the time for a query.

I've got no reason to waste your time, having seen your entirely flash
website I can see why you need to do something about it.

(sheesh, this reminds me of having to deal with students when I worked at a
university).

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com] 
Sent: 05 June 2007 12:47
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Do u have the solution or just wasting my time???

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 5:09 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason these aren't synchronized using NTP or a similar protocol
would be.......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:33
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Because the application is all about generating reports from the data in the
database. So I want to display the database server time and not the web
server time. It makes more sense to the users.
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 4:54 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason for not using the server time would be......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:21
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com]
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


[OT] Re: using jstl sql tags for displaying date from database

Posted by Oguz Kologlu <oz...@optusnet.com.au>.
Ambaris,

I think it's quite the opposite here, but anyway... the fact is it's  
database dependent.

Depending on the DB you may be able use "select now()" as  a query  
and if it doesn't work consult you DB manual. The question has  
nothing to do with struts

Oz

On 05/06/2007, at 9:46 PM, Ambaris Mohanty wrote:

> Do u have the solution or just wasting my time???
>
> -----Original Message-----
> From: Al Sutton [mailto:al@al-and-andrea.org.uk]
> Sent: Tuesday, June 05, 2007 5:09 PM
> To: 'Struts Users Mailing List'
> Subject: RE: using jstl sql tags for displaying date from database
>
> And the reason these aren't synchronized using NTP or a similar  
> protocol
> would be.......?
>
> -----Original Message-----
> From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
> Sent: 05 June 2007 12:33
> To: 'Struts Users Mailing List'
> Subject: RE: using jstl sql tags for displaying date from database
>
> Because the application is all about generating reports from the  
> data in the
> database. So I want to display the database server time and not the  
> web
> server time. It makes more sense to the users.
> AM
>
> -----Original Message-----
> From: Al Sutton [mailto:al@al-and-andrea.org.uk]
> Sent: Tuesday, June 05, 2007 4:54 PM
> To: 'Struts Users Mailing List'
> Subject: RE: using jstl sql tags for displaying date from database
>
> And the reason for not using the server time would be......?
>
> -----Original Message-----
> From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
> Sent: 05 June 2007 12:21
> To: 'Struts Users Mailing List'
> Subject: RE: using jstl sql tags for displaying date from database
>
> I want to display the same time in all the client machines  
> irrespective of
> their location.
>
> -----Original Message-----
> From: Dave Newton [mailto:newton.dave@yahoo.com]
> Sent: Tuesday, June 05, 2007 4:34 PM
> To: Struts Users Mailing List
> Subject: Re: using jstl sql tags for displaying date from database
>
> --- Ambaris Mohanty wrote:
>> And I want that the date should come from the
> database.
>
> Why would you want the current date to come from the database?
>
> d.
>
>
>
>
> ______________________________________________________________________ 
> ______
> ________
> Got a little couch potato?
> Check out fun summer activities for kids.
> http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities 
> +for+kids&c
> s=bz
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


[OT] RE: using jstl sql tags for displaying date from database

Posted by Dave Newton <ne...@yahoo.com>.
--- Ambaris Mohanty wrote:
> Do u have the solution or just wasting my time???

The irony here is thick enough to slice.

d.



      ____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect.  Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


RE: using jstl sql tags for displaying date from database

Posted by Ambaris Mohanty <am...@lifestylestores.com>.
Do u have the solution or just wasting my time???

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk] 
Sent: Tuesday, June 05, 2007 5:09 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason these aren't synchronized using NTP or a similar protocol
would be.......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com] 
Sent: 05 June 2007 12:33
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Because the application is all about generating reports from the data in the
database. So I want to display the database server time and not the web
server time. It makes more sense to the users.
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 4:54 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason for not using the server time would be......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:21
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com]
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


RE: using jstl sql tags for displaying date from database

Posted by Al Sutton <al...@al-and-andrea.org.uk>.
And the reason these aren't synchronized using NTP or a similar protocol
would be.......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com] 
Sent: 05 June 2007 12:33
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

Because the application is all about generating reports from the data in the
database. So I want to display the database server time and not the web
server time. It makes more sense to the users.
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk]
Sent: Tuesday, June 05, 2007 4:54 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason for not using the server time would be......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com]
Sent: 05 June 2007 12:21
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com]
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


RE: using jstl sql tags for displaying date from database

Posted by Ambaris Mohanty <am...@lifestylestores.com>.
Because the application is all about generating reports from the data in the
database. So I want to display the database server time and not the web
server time. It makes more sense to the users.
AM

-----Original Message-----
From: Al Sutton [mailto:al@al-and-andrea.org.uk] 
Sent: Tuesday, June 05, 2007 4:54 PM
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

And the reason for not using the server time would be......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com] 
Sent: 05 June 2007 12:21
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com]
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


RE: using jstl sql tags for displaying date from database

Posted by Al Sutton <al...@al-and-andrea.org.uk>.
And the reason for not using the server time would be......? 

-----Original Message-----
From: Ambaris Mohanty [mailto:ambaris.mohanty@lifestylestores.com] 
Sent: 05 June 2007 12:21
To: 'Struts Users Mailing List'
Subject: RE: using jstl sql tags for displaying date from database

I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com]
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


RE: using jstl sql tags for displaying date from database

Posted by Ambaris Mohanty <am...@lifestylestores.com>.
I want to display the same time in all the client machines irrespective of
their location.

-----Original Message-----
From: Dave Newton [mailto:newton.dave@yahoo.com] 
Sent: Tuesday, June 05, 2007 4:34 PM
To: Struts Users Mailing List
Subject: Re: using jstl sql tags for displaying date from database

--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the
database?

d.



       
____________________________________________________________________________
________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&c
s=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Re: using jstl sql tags for displaying date from database

Posted by Dave Newton <ne...@yahoo.com>.
--- Ambaris Mohanty wrote:
> And I want that the date should come from the
database.

Why would you want the current date to come from the
database?

d.



       
____________________________________________________________________________________
Got a little couch potato? 
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org