PHP Builder

Re: TIME(hh:mm:ss) new edit mode type?

javirebu — Wed Oct 03, 2007 10:01 am

Author: javirebu

Posted: Wed Oct 03, 2007 10:01 am

YES!!!!! thankyou master...

Re: TIME(hh:mm:ss) new edit mode type?

administrator — Tue Oct 02, 2007 6:18 pm

Author: administrator

Posted: Tue Oct 02, 2007 6:18 pm

Will be added in nearest version.

Re: TIME(hh:mm:ss) new edit mode type?

javirebu — Tue Oct 02, 2007 3:06 pm

Author: javirebu

Posted: Tue Oct 02, 2007 3:06 pm

thanks...

Something like this is what i am doing... but i think edit type TIME(hh:mm:ss) would be nice for datagrid, because TIME type of mysql exists...

best wishes!

Re: TIME(hh:mm:ss) new edit mode type?

zewa666 — Tue Oct 02, 2007 12:42 pm

Author: zewa666

Posted: Tue Oct 02, 2007 12:42 pm

you can use a simple datetime field and in MYSQL simply use this parameter when select.

DATE_FORMAT(YOURFIELD, xxx).

For your proper formating please google for MYSQL DATE_FORMAT and you will find the specs only to show the time without the date.

Greetings
Zewa

TIME(hh:mm:ss) new edit mode type?

javirebu — Tue Oct 02, 2007 11:03 am

Author: javirebu

Posted: Tue Oct 02, 2007 11:03 am

Hi all!
First of all i want to be thankful with all people who made possible this wonderful code to manage mysql BBDD.

I was very expectant on new version 4.2 of datagrid, because i am needing for my program some time data.

I only want to suggest top implement one more edit type, TIME(hh:mm:ss)
i think it would usefull for example to a schedules list.

Maybe i am wrong... but i think it is a good idea, i had one mysql table with beginTime and endTIME keys, of mysql TIME type, i try to edit in datetimedmy type with datagrid, but it only shows 4 first digits of date... finally i had to change mysql type with phpmyadmin to datetime, and it works, but i think i don't need at all date.

thanks a million again from MADRID Spain!

## *** Ex.: type = textbox|textarea|label|date(yyyy-mm-dd)|datedmy(dd-mm-yyyy)|datetime(yyyy-mm-dd hh:mm:ss)|datetimedmy(dd-mm-yyyy hh:mm:ss)|image|password|enum|print|checkbox
## *** make sure your WYSIWYG dir has 777 permissions