ERROR: "Please insert a Recordset to use Database Search" ...
I get the above error when attempting to use Database Search server behavior, or when attempting to use the Database Search Wizard. I inserted the database with the MySQLi Recordset server behavior. The database is inserted and visible in the 'bindings' list.
Here is the code for the recordset insertion ("recordset" substituted for actual database and recordset names)
<?php
$rs_Recordset = new WA_MySQLi_RS("rs_Recordset",$recordset,1);
$rs_Recordset->setQuery("SELECT * FROM recordset");
$rs_Recordset->execute();
?>
This is frustrating. Please advise.