2. PHPRunner General questions
  3. [SOLVED]  Date Time Stamp Problem
This topic is locked
[SOLVED]

 Date Time Stamp Problem

 		3/7/2008 1:13:43 PM
PHPRunner General questions
S
 stevenf author

I have a field called Date.
Type: timestamp.

Attributes: ON UPDATE CURRENT_TIMESTAMP

Default: CURRENT_TIMESTAMP
Which I set via PhpMyAdmin.
Via PhpMyAdmin, when I edit/add a record it will save the Date and Time.
All that works fine!
Now, in phprunner Ive set the field to DateTime and I'm using the Now() Function back it's not working.
Could it be that I need to somehow set the field to a text field and set it to after saving the record it updates and shows the fields read from the database?
Is that posible? Also...on the Edit/Add pages should I be setting the date field to hidden?
Can anyone help me with this please? I have 15 days left before I buy the software and I WILL if it can do this!
Hope someone can help!
Thanks
Stevenf
S
 		swanside 3/9/2008

I set my date in MySQL to "DATETIME"
In Phprunner, I go to the visual editor, double click on the date area and select edit as Date, I selected Dropdown boxes with datepicker. In the Default I enter now().
You can select Time if you wist, but I use another field for that. AGain in MySQL I have a Field for the Time which is set to VARCHAR (50).
In the visual editor I select Edit AS DATE and in the default box I enter "date('H:i:s');" all without the ".
Hope that works.
By the way, you are better off buying the program, The email support is Brilliant.

Swanny.
S
 		stevenf author 3/10/2008

I set my date in MySQL to "DATETIME"

In Phprunner, I go to the visual editor, double click on the date area and select edit as Date, I selected Dropdown boxes with datepicker. In the Default I enter now().
You can select Time if you wist, but I use another field for that. AGain in MySQL I have a Field for the Time which is set to VARCHAR (50).
In the visual editor I select Edit AS DATE and in the default box I enter "date('H:i:s');" all without the ".
Hope that works.
By the way, you are better off buying the program, The email support is Brilliant.

Swanny.


Hmm...I get a strange long format in the time field like 2039:1234:04 something like that! Also, it only displays it when i add a new record and now when I edit an existing one!

About buying the software 99% that I will....but I am not well-off financially I need 100% security that it's going to do what i need it to do!
S
 		stevenf author 3/10/2008

I set my date in MySQL to "DATETIME"

In Phprunner, I go to the visual editor, double click on the date area and select edit as Date, I selected Dropdown boxes with datepicker. In the Default I enter now().
You can select Time if you wist, but I use another field for that. AGain in MySQL I have a Field for the Time which is set to VARCHAR (50).
In the visual editor I select Edit AS DATE and in the default box I enter "date('H:i:s');" all without the ".
Hope that works.
By the way, you are better off buying the program, The email support is Brilliant.

Swanny.


This is the format i'm getting for the time: 2015:07:15
S
 		stevenf author 3/10/2008



This is the format i'm getting for the time: 2015:07:15


Here's an update!
When I click on Add New Record ... The time displays properly! BUT when I save and go to view it is in this format: 2015:07:15
Can anyone help please?
J
 		Jane 3/11/2008

Hi,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.