6 messages in com.mysql.lists.perlRe: Strange behavior with placeholders
FromSent OnAttachments
Chuck O'Donnell29 Mar 2001 06:05 
Greg Meckes29 Mar 2001 11:23 
Chuck O'Donnell29 Mar 2001 12:05 
Chuck O'Donnell29 Mar 2001 12:45 
Daniel J McDonald29 Mar 2001 12:56 
Chuck O'Donnell29 Mar 2001 13:03 
Subject:Re: Strange behavior with placeholders
From:Chuck O'Donnell (ca@bus.net)
Date:03/29/2001 01:03:34 PM
List:com.mysql.lists.perl

On Thu, Mar 29, 2001 at 02:56:54PM -0600, Daniel J McDonald wrote:

So, would a work-around be to tag the variable as a string? something like: $sth=$db->prepare('Select * from table where field = ?'); $var=$ARGV[0]; if ($var == 5) {do something}; $var .= ''; $sth->execute($var);

Yep, or just use

$sth->execute("$var");

and you're fine.

Chuck