[ILUG] Perl / MySQL oddity

[Nick Hilliard]

> > 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);
> 
> I tried using this syntax at some stage but had some kind of problem with it
> and didn't keep trying. However, 

Really?  What sort of problems did you have?

> > This gets around the need to mess around with quoting things all over the
> > place.  
> 
> I'm not sure that this is right. DBI->quote is to quote strings being passed
> to the server. I don't see how passing them via these bound parameters
> gets around this necessity.

I phrased that badly.  What I meant to say was "This gets around the need to
_explicitely_ quote things all over the place".  It's simply a neater
interface than messing around with DBI->quote, but does the same thing by
FETCH'ing them from within the execute() code, rather than by passing them
directly to do() and then execute().

Your problem is curious though.  I've looked at the XS code for quote() and
execute() but rapidly got lost in there (must dig out my perl internals book
one of these days).

Nick