This is probably more of a MySQL question.
Let's start with the code:

my $sth = $dbh->prepare('SELECT * FROM applicants WHERE last_name LIKE
+ "%?%"; ORDER BY date_col, job_position'); 
     $sth->execute($last_name) or die $sth->errstr;
[download]

Returns "execute called with 1 bind variables when 0 are needed"

What I'm trying to accomplish is searching the 'applicants' TABLE by column name 'last_name' using the LIKE statement. If I merely place text into this code it works. However, trying to pass a variable into it doesn't work. The $string in the sth works with a placeholder if I don't use LIKE. I've tried escaping the characters, putting the string directly in the LIKE statement and every variation I can think of.

Does anyone have any suggestions? I've looked at all my docs and mysql.com and found nothing about this.

peppiv

your lucky lotto numbers are 10 20 30 40 50!

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.