After making a Column name change in the mysql db (ProdID to ID), the results page now returns the entire Db no matter what is entered (the index page search works fine).
Looked at the record sets and server behaviors, including a DW Find for ProdID, and they all have been updated to ID. Not even sure this is the issue.
You manually corrected this problem previously by editing the Search parameter to look at the URL rather than the recordset, but didn't go into detail how you did it. However, it looks like the URL parameter ProdNum is being passed correctly.