MySQLi Query Issue

With this SQL I'm using in a MySQLi recordset typing in a partial value into a search field will not find any records but typing the complete value does. As an example, if I type in 'abe' no records are found, but if I type in 'abe lincoln', the record is found. Why is the LIKE condition not working in this SQL? Am I using an incorrectly formed variable? Using the MySQLi Query Builder doesn't build a successful SQL statement either.

SELECT publications.*
FROM publications
WHERE publications.Author LIKE varAuthor OR publications.Title LIKE varTitle OR publications.SubmitDate = varSubmitDate

You need to add your wildcard characters to your parameter string

http://www.w3schools.com/sql/sql_wildcards.asp

  (The variable is defined as: Name: varAuthor Type: text Default Value: -1 Runtime Value" <?php echo $_GET['Author']; ?> )  

For the like comparison, we created the Begins With, Ends With, and Contains Text variable types. In the variable definition, you need to set the type to one of those instead of using Text.

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();
?>

you started another thread for this issue and others, i asked for connect information there.