I'm using DMXZone’s PHP Database Connector and HTML5 Bindings when building a new site and now that I’m in the final stages something has happened which has caused several of my saved recordsets (which previously worked) to return 0 records. I've been applying a filter to the recordset, on a BIT datatype where the possible values are either 1 or 0, and these criteria *previously worked fine* with these queries. Now, 0 records are returned when these criteria are present. I'm absolutely stumped because it used to work, and now it doesn't!

These recordsets are based on saved MySql Views and I’ve confirmed that these SAVED views DO work in phpMyAdmin, Navicat, Sequel Pro and Querious, but do not return ANY records in my PHP pages, nor when loading the actual Database Source Name include files.

I'm including screen shots to show what is happening.


Screenshot 1: This datasource successfully returns records as expected when no WHERE criteria are present. You can see the BIT values returned for the Men and Women fields.




Screenshot 2: Here I'm adding a Filter for the "Men" field, which is a BIT type, with a length of 1. This previously worked fine on my pages. I had been able to run a criteria before for Men = 1 and Women = 0.




Screenshot 3: When running the Test Results with the filter value present, the recordset is empty! (I've also tried other values, still 0 records)




Screenshot 4: Here are the raw results returned from the srcProductList_DVD.php data source include file. Please also see the underlying code generated by the DMXzone extension.




Screenshot 5: Here is the database connection script the the reference to vwProductList_DVD highlighted.




Screenshot 6: Here is the underlying SQL for the saved view, vwProductList_DVD. This view runs fine here.






Again, this view does not return any recordsets in my PHP page, nor in the Database Source Include file, nor when testing the query in the Database Source Query Builder dialog box.

Here's what I've already tried to do to fix it, with no luck...

• I’ve tried to Test and re-apply all Database Connections in DMXZone extension dialog box
• I’ve tried to Reapply All datasource settings in the Database Source Query Builder dialog box
• I’ve also made sure I’ve renamed all BIT references of "b\'0\'" renamed "b'0'" and renamed "b'1'" to "b'1'" in the Database Source connection file, as you previously instructed by you in response to my prior support ticket which had solved my previous issues where ALL of my datasets were coming up blank. Now, only these specific views from the same tables are no longer loading, though all other datasources are loading fine. And these data sources worked fine this past week! I'm absolutely stumped.

Please, please help!