2. PHPRunner General questions
  3. Trouble with DateTime Field
This topic is locked

Trouble with DateTime Field

 		2/9/2007 19:29:23
PHPRunner General questions
C
 comlan author

I have added a new table to my database, and then added this table to my existing project.
When I go to add a record in the new table, the date and time show in the DateTime field, but when I hit "Submit", only the date portion is written to the database. The original tables that contain datetime field types are working just fine.
The only things I am aware of that have changed are:

  1. I am using a corrected version of "locale.php" that you provided me to resolve a problem in a previous post where there was an AM/PM issue between 12:00:00 PM and 12:59:00 PM.
  2. I have updated from build 207 to build 218.
    Any ideas as to what the problem might be?
    Thanks
J
 		Jane 2/12/2007

Please publish your project on Demo Account and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] 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.
C
 		comlan author 2/12/2007

After further checking, I have found the following additional information on this issue:

  1. When looking at the database using phpmyadmin, I find that the time has been written to the database by the "ADD NEW" option generated by PHPRunner.
  2. Using the "EDIT" option generated by PHPRunner the time is displayed. View and List display the date portion only.
  3. Using the "ADVANCED SEARCH" option generated by PHPRunner, the record is found only with the full "date and time".
  4. Using the "EXPORT" option generated by PHPRunner, only the "XML" option includes the "time", the others export the date portion only.
    I am wondering if a problem has been introduced since release 207?
    I could send to you the code generated by PHPRunner, or what do you suggest?
    Thanks for your help.
J
 		Jane 2/13/2007

Please make sure that you've selected Datetime on the "View as" settings dialog on the Visual Editor tab.
If it doesn't help publish your project on Demo Account and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] 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.
C
 		comlan author 2/13/2007

You are correct. I thought I had everything set, but missed the "View As" property.
Works now.
Thanks for your help.