=?iso-8859-1?Q?Ra=FAl_E._Rivero?=
|
| Posted: 06/27/2001, 10:00 PM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_024A_01C0FF77.32FB6060
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi to all.
I am starting with Codecharge with one database with Interbase and ASP. =
And have a problem with date fields. When insert a record not work very =
good, i need that the picture was DD/MM/YYYY but, when display the =
record, show the date format MM/DD/YYYY.
Who test this? What is the solution?
Thank in advance-
-------------------------------------------------------------------------=
-------
Ra=FAl=20
------=_NextPart_000_024A_01C0FF77.32FB6060
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi to all.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am starting with Codecharge with =
one=20
database with Interbase and ASP. And have a problem with date fields. =
When=20
insert a record not work very good, i need that the picture was =
DD/MM/YYYY but,=20
when display the record, show the date format =
MM/DD/YYYY.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Who test this? What is the =
solution?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thank in advance-</FONT></DIV>
<HR>
<DIV><FONT color=3Dblue size=3D+1><B>Ra=FAl =
</B></FONT><BR></DIV></BODY></HTML>
------=_NextPart_000_024A_01C0FF77.32FB6060--
|
|
|
 |
Nadeem
|
| Posted: 06/28/2001, 3:29 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0049_01C0FFCF.19993CC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Raul,
Do one thing:
In OPEN Event write:
Dim CurrMonth, CurrDay, CurrYear, CurrDate
CurrMonth =3D Month(Date())
if Len(CurrMonth )=3D1 Then CurrMonth =3D "0" & CurrMonth
CurrDay =3D Day(Date())
if Len(CurrDay )=3D1 Then CurrDay =3D "0" & CurrDay=20
CurrYear =3D Year(Date())
CurrDate =3D CurrDay & "/" & CurrMonth & "/" & CurrYear
Then in your field properties, replace "=3DDate()" with "=3DCurrDate"
This is how it worked for me.
Nadeem
Belgium
"Ra=FAl E. Rivero" <rerivero@adinet.com.uy> wrote in message =
news:9hedl5$23k$1@news.codecharge.com...
Hi to all.
I am starting with Codecharge with one database with Interbase and =
ASP. And have a problem with date fields. When insert a record not work =
very good, i need that the picture was DD/MM/YYYY but, when display the =
record, show the date format MM/DD/YYYY.
Who test this? What is the solution?
Thank in advance-
-------------------------------------------------------------------------=
-----
Ra=FAl=20
------=_NextPart_000_0049_01C0FFCF.19993CC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Raul,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Do one thing:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>In OPEN Event write:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Dim CurrMonth, CurrDay, CurrYear,=20
CurrDate<BR>CurrMonth =3D Month(Date())<BR>if Len(CurrMonth )=3D1 Then =
CurrMonth =3D=20
"0" & CurrMonth<BR>CurrDay =3D Day(Date())<BR>if Len(CurrDay )=3D1 =
Then CurrDay=20
=3D "0" & CurrDay <BR>CurrYear =3D Year(Date())<BR>CurrDate =3D =
CurrDay & "/"=20
& CurrMonth & "/" & CurrYear</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Then in your field properties, replace =
"=3DDate()"=20
with "=3DCurrDate"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>This is how it worked for =
me.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Nadeem</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Belgium</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ra=FAl E. Rivero" <<A=20
href=3D"mailto:rerivero@adinet.com.uy">rerivero@adinet.com.uy</A>> =
wrote in=20
message <A=20
=
href=3D"news:9hedl5$23k$1@news.codecharge.com">news:9hedl5$23k$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi to all.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am starting with Codecharge =
with one=20
database with Interbase and ASP. And have a problem with date fields. =
When=20
insert a record not work very good, i need that the picture was =
DD/MM/YYYY=20
but, when display the record, show the date format =20
MM/DD/YYYY.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Who test this? What is the =
solution?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thank in advance-</FONT></DIV>
<HR>
<DIV><FONT color=3Dblue size=3D+1><B>Ra=FAl=20
</B></FONT><BR></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0049_01C0FFCF.19993CC0--
|
|
|
|
=?iso-8859-1?Q?Ra=FAl_E._Rivero?=
|
| Posted: 06/28/2001, 5:27 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0017_01C0FFB4.A3FDF6A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks Nadeem.
I try this.
Ra=FAl.
"Nadeem" <n.malik@usa.net> escribi=F3 en el mensaje =
news:9hf0v4$610$1@news.codecharge.com...
Hi Raul,
Do one thing:
In OPEN Event write:
Dim CurrMonth, CurrDay, CurrYear, CurrDate
CurrMonth =3D Month(Date())
if Len(CurrMonth )=3D1 Then CurrMonth =3D "0" & CurrMonth
CurrDay =3D Day(Date())
if Len(CurrDay )=3D1 Then CurrDay =3D "0" & CurrDay=20
CurrYear =3D Year(Date())
CurrDate =3D CurrDay & "/" & CurrMonth & "/" & CurrYear
Then in your field properties, replace "=3DDate()" with "=3DCurrDate"
This is how it worked for me.
Nadeem
Belgium
"Ra=FAl E. Rivero" <rerivero@adinet.com.uy> wrote in message =
news:9hedl5$23k$1@news.codecharge.com...
Hi to all.
I am starting with Codecharge with one database with Interbase and =
ASP. And have a problem with date fields. When insert a record not work =
very good, i need that the picture was DD/MM/YYYY but, when display the =
record, show the date format MM/DD/YYYY.
Who test this? What is the solution?
Thank in advance-
-------------------------------------------------------------------------=
---
Ra=FAl=20
------=_NextPart_000_0017_01C0FFB4.A3FDF6A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Thanks Nadeem.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I try this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Ra=FAl.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Nadeem" <<A =
href=3D"mailto:n.malik@usa.net">n.malik@usa.net</A>>=20
escribi=F3 en el mensaje <A=20
=
href=3D"news:9hf0v4$610$1@news.codecharge.com">news:9hf0v4$610$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi Raul,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Do one thing:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>In OPEN Event write:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Dim CurrMonth, CurrDay, CurrYear,=20
CurrDate<BR>CurrMonth =3D Month(Date())<BR>if Len(CurrMonth )=3D1 Then =
CurrMonth =3D=20
"0" & CurrMonth<BR>CurrDay =3D Day(Date())<BR>if Len(CurrDay )=3D1 =
Then=20
CurrDay =3D "0" & CurrDay <BR>CurrYear =3D =
Year(Date())<BR>CurrDate =3D CurrDay=20
& "/" & CurrMonth & "/" & CurrYear</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Then in your field properties, =
replace "=3DDate()"=20
with "=3DCurrDate"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>This is how it worked for =
me.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Nadeem</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Belgium</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ra=FAl E. Rivero" <<A=20
=
href=3D"mailto:rerivero@adinet.com.uy">rerivero@adinet.com.uy</A>> =
wrote in=20
message <A=20
=
href=3D"news:9hedl5$23k$1@news.codecharge.com">news:9hedl5$23k$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi to all.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am starting with Codecharge =
with one=20
database with Interbase and ASP. And have a problem with date =
fields. When=20
insert a record not work very good, i need that the picture was =
DD/MM/YYYY=20
but, when display the record, show the date format =20
MM/DD/YYYY.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Who test this? What is the=20
solution?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thank in advance-</FONT></DIV>
<HR>
<DIV><FONT color=3Dblue size=3D+1><B>Ra=FAl=20
</B></FONT><BR></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0017_01C0FFB4.A3FDF6A0--
|
|
|
|
=?iso-8859-1?Q?Fr=E9d=E9ric_Malenfant?=
|
| Posted: 06/28/2001, 6:43 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0023_01C0FFB6.C93C5900
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
habitually, if SQL is configured to use english and/or your SQL server =
is configured in regional settings for english, the date you pass to and =
receive from SQL is "MM/DD/YYYY" so you have to convert this in the =
beforesave to save correctly if your user types its date in dd/mm/yyyy =
format, and same thing when you read, somewhere in the "beforeshow" =
event (I don't know if beforeshow exists...) somethign like that you =
convert what you receive from SQL (mm/dd/yyyy) to what you want to =
display. use the mid, left, right ASP functions to modify your string! =
I always have to do that because in french we write in dd/mm/yyyy and =
all the SQL server are always in mm/dd/yyyy configuration...
------=_NextPart_000_0023_01C0FFB6.C93C5900
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>habitually, if SQL is configured to use =
english=20
and/or your SQL server is configured in regional settings for english, =
the date=20
you pass to and receive from SQL is "MM/DD/YYYY" so you have to convert =
this in=20
the beforesave to save correctly if your user types its date in =
dd/mm/yyyy=20
format, and same thing when you read, somewhere in the "beforeshow" =
event (I=20
don't know if beforeshow exists...) somethign like that you convert what =
you=20
receive from SQL (mm/dd/yyyy) to what you want to display. use the =
mid,=20
left, right ASP functions to modify your string! I always have to do =
that=20
because in french we write in dd/mm/yyyy and all the SQL server are =
always in=20
mm/dd/yyyy configuration...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0023_01C0FFB6.C93C5900--
|
|
|
|
=?iso-8859-1?Q?Ra=FAl_E._Rivero?=
|
| Posted: 06/28/2001, 8:12 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0124_01C0FFCB.8734C3C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks
have you an example of code about this???
Thanks in advance.
RAUL
"Fr=E9d=E9ric Malenfant" <frederic.malenfant@cgi.ca> escribi=F3 en el =
mensajenews:9hfca2$r47$1@news.codecharge.com...
habitually, if SQL is configured to use english and/or your SQL server =
is configured in regional settings for english, the date you pass to and =
receive from SQL is "MM/DD/YYYY" so you have to convert this in the =
beforesave to save correctly if your user types its date in dd/mm/yyyy =
format, and same thing when you read, somewhere in the "beforeshow" =
event (I don't know if beforeshow exists...) somethign like that you =
convert what you receive from SQL (mm/dd/yyyy) to what you want to =
display. use the mid, left, right ASP functions to modify your string! =
I always have to do that because in french we write in dd/mm/yyyy and =
all the SQL server are always in mm/dd/yyyy configuration...
------=_NextPart_000_0124_01C0FFCB.8734C3C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>have you an example of code about=20
this???</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><BR>RAUL</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Fr=E9d=E9ric Malenfant" <<A=20
=
href=3D"mailto:frederic.malenfant@cgi.ca">frederic.malenfant@cgi.ca</A>&g=
t;=20
escribi=F3 en el mensaje <A=20
=
href=3D"news:9hfca2$r47$1@news.codecharge.com">news:9hfca2$r47$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>habitually, if SQL is configured to =
use english=20
and/or your SQL server is configured in regional settings for english, =
the=20
date you pass to and receive from SQL is "MM/DD/YYYY" so you have to =
convert=20
this in the beforesave to save correctly if your user types its date =
in=20
dd/mm/yyyy format, and same thing when you read, somewhere in the =
"beforeshow"=20
event (I don't know if beforeshow exists...) somethign like that you =
convert=20
what you receive from SQL (mm/dd/yyyy) to what you want to =
display. use=20
the mid, left, right ASP functions to modify your string! I always =
have to do=20
that because in french we write in dd/mm/yyyy and all the SQL server =
are=20
always in mm/dd/yyyy configuration...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0124_01C0FFCB.8734C3C0--
|
|
|
|
|
