PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WEBDEV 2024 → Time fields in mysql
Time fields in mysql
Started by Mike Stewart, Aug., 12 2018 3:51 PM - No answer
Posted on August, 12 2018 - 3:51 PM
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)