rherson1

Hi Peter, I have now identified the problem. I had to cast the offending column’s content to CHAR within the view i.e.

cast(‘Time since last flight in hours:minutes:seconds’ as CHAR) as vAnalysisPeriod # mysql

It now works so the topic is resolved.

Thanks and regards.

Richard.

Thanks for your answer. I’ve now got it working by making a change to the Web Server document directory and also updating the WP config file to point to use the updated site details.

Richard.

Thanks Peter. As per your suggestion I have added the following jquery conditions via the advanced table options.

{
“paging”: true,
“pageLength”: 5,
“dom”: “t”
}

If I change the “pageLength” value to 3 then 3 lines are returned – which is as required. However, if I don’t clear the Browser cache (Chrome) then it takes a few hours for the new value to take effect. When I clear the Browser cache manually then the new value is immediately active. Not sure what’s going on here and would like to understand better!

Also I still don’t understand how JQUERY via APEX work together to limit the number of rows obtained from a MYSQL query because APEX, which populates an HTML table, gets its data from the JSON array which in turn is populated by running a PHP / MySQL SQL script where the LIMIT condition would be applied. I dare say my understanding of the architecture is a bit suspect!

Thanks.

Richard.