Hi.
por favor necesito ayuda!!!, tengo un form con varios Text Box y DatePicker, el problema esta cuando debe guardar en la base de datos, solo graba los TextBox.
El la tabla de DB los campos para el DatePicker son de tipo Date, al visualizar la table solo se ve 0000-00-00
Gracias.
Google translate:
Please I need help !!! I have a form with several Text Box and DatePicker, the problem is when you must save in the database, only records the TextBox.
The DB table fields for DatePicker type are Date, to display the table only look 0000-00-00
por favor necesito ayuda!!!, tengo un form con varios Text Box y DatePicker, el problema esta cuando debe guardar en la base de datos, solo graba los TextBox.
El la tabla de DB los campos para el DatePicker son de tipo Date, al visualizar la table solo se ve 0000-00-00
Gracias.
Google translate:
Please I need help !!! I have a form with several Text Box and DatePicker, the problem is when you must save in the database, only records the TextBox.
The DB table fields for DatePicker type are Date, to display the table only look 0000-00-00
Data Array
Array
(
[chronoform] => frmRegistroCandidato
[event] => submit
[vdni] =>
[vnombres] => SDAS DAS D
[vappaterno] => ASDASD ASD AD
[vapmaterno] =>
[vtelefmovil] =>
[vteleffijo] =>
[vemail] =>
[vdireccion] =>
[vdepartamento] => LAMBAYEQUE
[vciudad] => CHICLAYO
[vreferido] => COMPUTRABAJO
[vcaptacion] => PENDIENTE
[vflujo] => PENDIENTE
[vfechaentrevista] => 26/07/2015
[vhorarentrevista] =>
[vfechainicioformacion] => 27/07/2015
[vhoraformacion] =>
[vfechafinformacion] => 28/07/2015
[vfechacontratacion] => 29/07/2015
[vobservaciones] =>
[btnGrabar] => Grabar Datos
[vhoraentrevista] =>
[id] => 10
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
[11] => Array
(
[DB Save] => Array
(
[Queries] => Array
(
[0] => INSERT INTO `diqr_cf_candidatos` (`vdni`, `vnombres`, `vappaterno`, `vapmaterno`, `vtelefmovil`, `vteleffijo`, `vemail`, `vdireccion`, `vdepartamento`, `vciudad`, `vreferido`, `vcaptacion`, `vflujo`, `vfechaentrevista`, `vhorarentrevista`, `vfechainicioformacion`, `vhoraformacion`, `vfechafinformacion`, `vfechacontratacion`, `vobservaciones`, `user_id`, `uniq_id`, `created`) values ('', 'SDAS DAS D', 'ASDASD ASD AD', '', '', '', '', '', 'LAMBAYEQUE', 'CHICLAYO', 'COMPUTRABAJO', 'PENDIENTE', 'PENDIENTE', '26/07/2015', '', '27/07/2015', '', '28/07/2015', '29/07/2015', '', '511', '3082b17c2c8e4c951bd04860c740bb6f0a3cbf3c', '2015-07-31 10:20:43');
)
)
)
)
Hi roblosky,
To save the dates in the database table as type DATE they need to be in the format yyyy-mm-dd that is - 2017-07-29 and not 29/07/2015
You can either change the format setting in the DatePicker elements or use a Custom Code action before the DB Save to change the format of these values.
Bob
To save the dates in the database table as type DATE they need to be in the format yyyy-mm-dd that is - 2017-07-29 and not 29/07/2015
You can either change the format setting in the DatePicker elements or use a Custom Code action before the DB Save to change the format of these values.
Bob
This topic is locked and no more replies can be posted.