When I use "Contains text" I get no records found. Going back to "text" will find results as long as I use complete parameters. What am I doing wrong?
Here's the PHP that MySQLi generates:
<?php
$rsSearch = new WA_MySQLi_RS("rsSearch",$JUA_i,1);
$rsSearch->setQuery("SELECT publications.* FROM publications WHERE publications.Author LIKE ? OR publications.Title LIKE ? OR publications.SubmitDate = ?");
$rsSearch->bindParam("s", "".((isset($_GET["Author"]))?$_GET["Author"]:"") ."", "-1"); //varAuthor
$rsSearch->bindParam("s", "".((isset($_GET["Title"]))?$_GET["Title"]:"") ."", "-1"); //varTitle
$rsSearch->bindParam("t", "".((isset($_GET["SubmitDate"]))?$_GET["SubmitDate"]:"") ."", "-1"); //varSubmitDate
$rsSearch->execute();
?>