PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 2024 → Time fields in mysql
Time fields in mysql
Débuté par Mike Stewart, 12 aoû. 2018 15:51 - Aucune réponse
Posté le 12 août 2018 - 15:51
We have an application using MySQL and there is some sort of problem using time values

The records are being created but the time values are NULL.

We have tried various formats

We have used INSERT queries
or hAdd

When the system is in PHP Test mode the records can be created and the times are put in. However, in normal PHP the site crashes with no errors.

tSt is Time = StringToTime(arr1[nEDTperiod,2],"HHMMSS")
tEn is Time = StringToTime(arr1[nEDTperiod,3],"HHMMSS")
sSt is string = TimeToString(tSt,"HHMMSS")
sEn is string = TimeToString(tEn,"HHMMSS")

// sSQL is string = [
// INSERT INTO `sys`.`day_timings` (`day`, `start`, `finish`, `appliesToGroup`, `periodName`)
// VALUES ('11', [%arr1[nEDTperiod,2]%], [%arr1[nEDTperiod,3]%], 'evwev', 'vwevw')
// ]
// mySqlData is a data source
// HExecuteSQLQuery(mySqlData, sSQL)
//test ? still here mate ? sorry yes
//yes
//Trace(arr1[nEDTperiod,2], sEn)
day_timings.day = nAppliesToDays
day_timings.finish = 140920 //no need
day_timings.start = "151032"
Trace(day_timings.finish + " " + day_timings.start)
day_timings.periodName = arr1[nEDTperiod,1]
day_timings.appliesToGroup = gsGname
HAdd(day_timings)