|
| |
|
|
Dealer58
Posts: 174
From: New York (was in Germany)
Status: offline
 |
Session.lcid question - 3/13/2003 1:00:21
I have a web on a server in the UK. I need the date to read from the DB and output it as mm/dd/yyyy as opposed to the dd/mm/yyyy reading that I am getting.
I am also getting the Pound sign instead of th $ sign that I need.
I understand that if I set the Session.lcid= something I can correct this problem.
I look at the 4guys fromrolla site and they sent me to the MSDN library but I cannot find the correct table. It' s too confusing.
Does anybdy know what the session.lcid values are for the US date and $ sign?
CC
|
|
|
|
Stuart at Cherry
Posts: 121
From: Leeds, West Yorkshire, UK
Status: offline
|
RE: Session.lcid question - 3/14/2003 4:00:23
I think you' ll find it' s 1033
Cool.
_____________________________
***born to be wild***
| |
|
|
|
Dealer58
Posts: 174
From: New York (was in Germany)
Status: offline
|
RE: Session.lcid question - 3/14/2003 18:01:17
Correction,
<%
session.LCID = 1033
EndDate = FP_FieldVal(fp_rs," EndDate" )
%>
does not work! Errors on page!
<%
session.LCID = 1033
%>
returns the $ sign and dd/mm/yyyy. I need mm/dd/yyyy
What to do?
Please Advise
CC
< Message edited by dealer58 -- 3/14/2003 10:02 PM >
| |
|
|
|
Dealer58
Posts: 174
From: New York (was in Germany)
Status: offline
|
RE: Session.lcid question - 3/15/2003 11:18:33
I have come to the conclusion that the session.lcid has no effect on changing the date format that is being passed from a DB whose regional settings are set otherwise.
When the work is done without involving a variable that is being passed from the DB e.g.
<%
session.LCID = 1033
Respnse.Write Date()
%>
The result is correct.
<%
session.LCID = 1033
%>
or something like
<%
session.LCID = 1033
EndDate = FP_FieldVal(fp_rs," EndDate" )
%>
has no effect on the date format that the DB is passing, even thought the one being stored is in the correct format.
Please Advise
Regards
CC
| |
|
|
|
ASPPlayground
Posts: 122
Joined: 6/25/2002
From: Toronto, Canada
Status: offline
|
RE: Session.lcid question - 3/16/2003 20:21:49
quote:
session.lcid has no effect on changing the date format
It does, but you need to use FormatDateTime() to get it right.
<%
session.LCID = 1033
EndDate = FormatDateTime(FP_FieldVal(fp_rs," EndDate" ))
%>
will definitely work.
_____________________________
Samuel Chou
ASPPlayground.NET Developer
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
