hi, The two Service Providers (SPA and SPB) are using different versions of PHP and MySQL, the details is as follow. One point to note is that the flex app is called testdb which will retrieve data from a DB called bookclub which has 2 tables called staff and position and 2 views called staffviewposition and staffviewpositionnoiddposition. In *SPA*, all data from 2 tables and 2 views can be retrieved successfully and displayed in 4 separate datagrids (see http://www.bbrchk.com/testdb/testdb.html) while in *SPB* the data from the 2 tables can be retrieved successfully while view data cannot (see http://www.bbrclubhk.com/testdb/testdb.html). in SPB, it occurred to me the version may not be a problem because table data retrieval is OK but of course it might has problem with view, I don't know. This kind of flex app (using view) is very common and wonder how other developer deal with this.
FYI, I have used PHPMyAdmin to test the MySQL view staffviewposition and worked perfect, all data can be viewed. /Service provider A/ *Database server* Server: 10.100.5.140 via TCP/IP Server type: MySQL Server connection: SSL is not being used Server version: 5.6.36 - MySQL Community Server (GPL) Protocal version: 10 User: dwu@10.100.5.130 Server charset: cp1252 West European (latin 1) *Web server* nginx/1.11.10 Database client version: libmysql - mysqlnd 5.0.12 PHP extension: mysqli curl mbstring PHP version: 7.1.14 *phpMyAdmin* Version information: 4.9.0.1 *Zendframework* Version: 1.11.2 /Service provider B/ *Database server* Server: Localhost via UNIX socket Server type: MariaDB Server connection: SSL is not being used Server version: 10.2.30-MariaDB - MariaDB Server Protocol version: 10 User: bbrclubh@localhost Server charset: cp1252 West European (latin1) *Web server* cpsrvd 11.84.0.19 Database client version: libmysql - 5.6.43 PHP extension: mysqli curl mbstring PHP version: 7.3.6 *phpMyAdmin* Version information: 4.9.0.1 *Zendframework* Version: 1.11.2 *Database server* Server: Localhost via UNIX socket Server type: MariaDB Server connection: SSL is not being used Server version: 10.2.30-MariaDB - MariaDB Server Protocol version: 10 User: bbrclubh@localhost Server charset: cp1252 West European (latin1) *Web server* cpsrvd 11.84.0.19 Database client version: libmysql - 5.6.43 PHP extension: mysqli curl mbstring PHP version: 7.3.6 *phpMyAdmin* Version information: 4.9.0.1 *Zendframework* Version: 1.11.2 -- Sent from: http://apache-flex-users.2333346.n4.nabble.com/