RonB
|
| Posted: 05/19/2002, 8:42 AM |
|
I'm working with beta 4, win2000/php/mysql.
Since upgrading to beta 4 none of my datefields are displaying. I only get
empty fields. Even if I turn of all date formatting I still get no dates.
Any ideas?
RonB
|
|
|
 |
RonB
|
| Posted: 05/19/2002, 8:44 AM |
|
"RonB" <r.borkent@123chello.nl> schreef in bericht
news:ac8h5b$ksa$1@news.codecharge.com...
> I'm working with beta 4, win2000/php/mysql.
>
> Since upgrading to beta 4 none of my datefields are displaying. I only get
> empty fields. Even if I turn of all date formatting I still get no dates.
> Any ideas?
>
> RonB
>
>
Oh if I turn date fields into text fields I get the date showing but cant
use the date formatting feature and have to fall back on my own date
conversion functions.
RonB
|
|
|
|
Kristian
|
| Posted: 05/19/2002, 10:53 AM |
|
Working in same environment having same problem.
Trying date format "dd/mm/YY" with forum application initializes the date
field to "01/01/1970" in the NEWTREAD procedure.
--
Kristian Hyllestad
SPINE AS (www.spine.no)
NORWAY
|
|
|
|
Steven Dowd
|
| Posted: 05/19/2002, 10:58 AM |
|
I have this same date error , not figured what it is yet, whether its a
fault in the project, or a fault in beta 4
Steven
"Kristian" <kristian@spinenospam.no> wrote in message
news:Xns9213CB4895B27kristianspinekundeco@66.180.229.147...
> Working in same environment having same problem.
>
> Trying date format "dd/mm/YY" with forum application initializes the date
> field to "01/01/1970" in the NEWTREAD procedure.
>
>
> --
> Kristian Hyllestad
> SPINE AS (www.spine.no)
> NORWAY
|
|
|
|
RonB
|
| Posted: 05/19/2002, 11:08 AM |
|
"Steven Dowd" <newspost.steven.dowd@dowd.co.uk> schreef in bericht
news:ac8p3f$32j$1@news.codecharge.com...
> I have this same date error , not figured what it is yet, whether its a
> fault in the project, or a fault in beta 4
>
> Steven
>
Maybe they haven't fixed the date stuff for php yet, didn't work in beta 3
so maybe they fixed it for asp but not for php?
RonB
|
|
|
|
Alexey Alexapolsky
|
| Posted: 05/20/2002, 4:48 AM |
|
Thanks, I've contacted our developers regarding this issue.
--
Alex
CodeCharge Developer
"RonB" <r.borkent@123chello.nl> wrote in message
news:ac8h5b$ksa$1@news.codecharge.com...
> I'm working with beta 4, win2000/php/mysql.
>
> Since upgrading to beta 4 none of my datefields are displaying. I only get
> empty fields. Even if I turn of all date formatting I still get no dates.
> Any ideas?
>
> RonB
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 05/20/2002, 8:36 AM |
|
If you use PHP + ODBC,mysql or postgreSQL , you should specify the following
"Date format" property in Connection/Server tab :
yyyy-mm-dd HH:nn:ss
This format is required because type of datefields is timestamp,
this info is required for timestamps to work properly.
Naturally, date format specified in other parts of project such as
Project settings/Date Display format is not required to be like the one
specified above.
--
Alex
CodeCharge Developer
"RonB" <r.borkent@123chello.nl> wrote in message
news:ac8h5b$ksa$1@news.codecharge.com...
> I'm working with beta 4, win2000/php/mysql.
>
> Since upgrading to beta 4 none of my datefields are displaying. I only get
> empty fields. Even if I turn of all date formatting I still get no dates.
> Any ideas?
>
> RonB
>
>
|
|
|
|
Dave Rexel
|
| Posted: 05/20/2002, 10:09 AM |
|
Alex is brilliant, as usual, hopefuly dates wiil be correcly initialised in
the release.
I spent an hour solving this myself last night.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:acb55v$ag9$2@news.codecharge.com...
> If you use PHP + ODBC,mysql or postgreSQL , you should specify the
following
> "Date format" property in Connection/Server tab :
>
> yyyy-mm-dd HH:nn:ss
>
> This format is required because type of datefields is timestamp,
> this info is required for timestamps to work properly.
> Naturally, date format specified in other parts of project such as
> Project settings/Date Display format is not required to be like the one
> specified above.
>
> --
> Alex
> CodeCharge Developer
>
>
> "RonB" <r.borkent@123chello.nl> wrote in message
>news:ac8h5b$ksa$1@news.codecharge.com...
> > I'm working with beta 4, win2000/php/mysql.
> >
> > Since upgrading to beta 4 none of my datefields are displaying. I only
get
> > empty fields. Even if I turn of all date formatting I still get no
dates.
> > Any ideas?
> >
> > RonB
> >
> >
>
>
|
|
|
|
Kristian
|
| Posted: 05/20/2002, 10:18 AM |
|
> If you use PHP + ODBC,mysql or postgreSQL , you should specify the
> following "Date format" property in Connection/Server tab :
>
> yyyy-mm-dd HH:nn:ss
>
> This format is required because type of datefields is timestamp,
> this info is required for timestamps to work properly.
> Naturally, date format specified in other parts of project such as
> Project settings/Date Display format is not required to be like the
> one specified above.
It didn't solve the problem during my testing. During some testing I saw
that the date ($DateToFormat) value used in the
function CCFormatDate($DateToFormat, $FormatMask)
changed between a unix timestamp and a string. So by changing the initial
value set to the date variable like shown below, it works.
Changing
$this->date_add->SetValue(date("m/d/Y H:i:s"));
to
$this->date_add->SetValue(strtotime(date("m/d/Y H:i:s")));
in the NEWTREAD procedure.
//Class_Initialize Event @2-D457E0AA
function clsRecordmessages()
{
.......
$this->Cancel = new clsButton("Cancel");
if(!$this->FormSubmitted) {
if(!strlen($this->smiley_id->GetValue()))
$this->smiley_id->SetValue(0);
if(!strlen($this->date_add->GetValue()))
$this->date_add->SetValue(strtotime(date("m/d/Y H:i:s")));
}
}
}
//End Class_Initialize Event
--
Kristian Hyllestad
SPINE AS (www.spine.no)
NORWAY
|
|
|
|
Dave Rexel
|
| Posted: 05/20/2002, 10:40 AM |
|
Hello Kristian
I also met these problems with the Forum example using PHP and found what I
hope is a simpler solution to this (it also solves the B-4 line 77 error in
forum reply page)
In Design Mode:
Open the forum reply page, message form and click on the date_add hidden
button in the Project Explorer to show its properties.
Now in the Properties panel, Data tab find the field Default and paste this
into it ---- date("Y-m-d H:i:s") ---
Voila CCS now generates the correct date code and the reply page shows in
design mode.
Hope this helps,
Dave
"Kristian" <kristian@spinenospam.no> wrote in message
news:Xns9214C5498A881kristianspinekundeco@66.180.229.147...
> > If you use PHP + ODBC,mysql or postgreSQL , you should specify the
> > following "Date format" property in Connection/Server tab :
> >
> > yyyy-mm-dd HH:nn:ss
> >
> > This format is required because type of datefields is timestamp,
> > this info is required for timestamps to work properly.
> > Naturally, date format specified in other parts of project such as
> > Project settings/Date Display format is not required to be like the
> > one specified above.
>
> It didn't solve the problem during my testing. During some testing I saw
> that the date ($DateToFormat) value used in the
> function CCFormatDate($DateToFormat, $FormatMask)
> changed between a unix timestamp and a string. So by changing the initial
> value set to the date variable like shown below, it works.
>
> Changing
> $this->date_add->SetValue(date("m/d/Y H:i:s"));
> to
> $this->date_add->SetValue(strtotime(date("m/d/Y H:i:s")));
> in the NEWTREAD procedure.
>
> //Class_Initialize Event @2-D457E0AA
> function clsRecordmessages()
> {
> ......
> $this->Cancel = new clsButton("Cancel");
> if(!$this->FormSubmitted) {
> if(!strlen($this->smiley_id->GetValue()))
> $this->smiley_id->SetValue(0);
> if(!strlen($this->date_add->GetValue()))
> $this->date_add->SetValue(strtotime(date("m/d/Y H:i:s")));
> }
> }
> }
> //End Class_Initialize Event
>
>
>
>
> --
> Kristian Hyllestad
> SPINE AS (www.spine.no)
> NORWAY
|
|
|
|
Kristian
|
| Posted: 05/20/2002, 12:08 PM |
|
Thanks Dave,
> In Design Mode:
> Open the forum reply page, message form and click on the date_add
> hidden button in the Project Explorer to show its properties.
>
> Now in the Properties panel, Data tab find the field Default and paste
> this into it ---- date("Y-m-d H:i:s") ---
> Voila CCS now generates the correct date code and the reply page shows
> in design mode.
Your way to make the changes was supurb so I'll adopt that. But it made
basically no difference. Using your suggestion the date still ends up
with 01/01/1970 in my case.
If I add 'strtotime(date("Y-m-d H:i:s"))' instead of only 'date("Y-m-d
H:i:s")' it works again.
I definite not in control with all CCS concepts so I'm stumbling
ahead...but it looks great!
--
Kristian Hyllestad
SPINE AS (www.spine.no)
NORWAY
|
|
|
|
Dave Rexel
|
| Posted: 05/20/2002, 12:46 PM |
|
Excellent, I tried that and it worked too.
Tack själv!
Dave
"Kristian" <kristian@spinenospam.no> wrote in message
news:Xns9214D7FEAE767kristianspinekundeco@66.180.229.147...
> Thanks Dave,
>
> > In Design Mode:
> > Open the forum reply page, message form and click on the date_add
> > hidden button in the Project Explorer to show its properties.
> >
> > Now in the Properties panel, Data tab find the field Default and paste
> > this into it ---- date("Y-m-d H:i:s") ---
> > Voila CCS now generates the correct date code and the reply page shows
> > in design mode.
>
>
> Your way to make the changes was supurb so I'll adopt that. But it made
> basically no difference. Using your suggestion the date still ends up
> with 01/01/1970 in my case.
>
> If I add 'strtotime(date("Y-m-d H:i:s"))' instead of only 'date("Y-m-d
> H:i:s")' it works again.
>
> I definite not in control with all CCS concepts so I'm stumbling
> ahead...but it looks great!
>
>
>
> --
> Kristian Hyllestad
> SPINE AS (www.spine.no)
> NORWAY
|
|
|
|
Steven Dowd
|
| Posted: 05/20/2002, 1:06 PM |
|
I suppose this should be added to the newthread page as well ?
Steven
"Kristian" <kristian@spinenospam.no> wrote in message
news:Xns9214D7FEAE767kristianspinekundeco@66.180.229.147...
> Thanks Dave,
>
> > In Design Mode:
> > Open the forum reply page, message form and click on the date_add
> > hidden button in the Project Explorer to show its properties.
> >
> > Now in the Properties panel, Data tab find the field Default and paste
> > this into it ---- date("Y-m-d H:i:s") ---
> > Voila CCS now generates the correct date code and the reply page shows
> > in design mode.
>
>
> Your way to make the changes was supurb so I'll adopt that. But it made
> basically no difference. Using your suggestion the date still ends up
> with 01/01/1970 in my case.
>
> If I add 'strtotime(date("Y-m-d H:i:s"))' instead of only 'date("Y-m-d
> H:i:s")' it works again.
>
> I definite not in control with all CCS concepts so I'm stumbling
> ahead...but it looks great!
>
>
>
> --
> Kristian Hyllestad
> SPINE AS (www.spine.no)
> NORWAY
|
|
|
|
Dave Rexel
|
| Posted: 05/20/2002, 1:09 PM |
|
I agree
dx
"Steven Dowd" <newspost.steven.dowd@dowd.co.uk> wrote in message
news:acbkvk$96u$1@news.codecharge.com...
> I suppose this should be added to the newthread page as well ?
>
> Steven
>
> "Kristian" <kristian@spinenospam.no> wrote in message
>news:Xns9214D7FEAE767kristianspinekundeco@66.180.229.147...
> > Thanks Dave,
> >
> > > In Design Mode:
> > > Open the forum reply page, message form and click on the date_add
> > > hidden button in the Project Explorer to show its properties.
> > >
> > > Now in the Properties panel, Data tab find the field Default and paste
> > > this into it ---- date("Y-m-d H:i:s") ---
> > > Voila CCS now generates the correct date code and the reply page shows
> > > in design mode.
> >
> >
> > Your way to make the changes was supurb so I'll adopt that. But it made
> > basically no difference. Using your suggestion the date still ends up
> > with 01/01/1970 in my case.
> >
> > If I add 'strtotime(date("Y-m-d H:i:s"))' instead of only 'date("Y-m-d
> > H:i:s")' it works again.
> >
> > I definite not in control with all CCS concepts so I'm stumbling
> > ahead...but it looks great!
> >
> >
> >
> > --
> > Kristian Hyllestad
> > SPINE AS (www.spine.no)
> > NORWAY
>
>
|
|
|
|
|
