[ILUG] Perl / MySQL oddity

[Nick Hilliard]

> #  $title = $2;
> 
> $values = join ",", $dbh->quote($Description),
>  $dbh->quote(substr($Description, 0, 50)), $dbh->quote($2), 
>  $dbh->quote($Keywords), $dbh->quote($UnixPath),
>  $dbh->quote($MacPath), $dbh->quote($Volume);
>  
> $dbh->do("INSERT INTO $table $Fields VALUES ($values)");

On a stylistic point, the recommended way to do this sort of thing is:

$sth = $dbh->prepare("INSERT INTO $table $Fields VALUES (?,?,?,?,?,?,?)");
$sth->execute(	$Description, substr($Description, 0, 50),
		$2, $Keywords, $UnixPath, $MacPath, $Volume);

This gets around the need to mess around with quoting things all over the
place.  Will this work around your problem? (I haven't tested it).

Nick