On Jun 14, 6:59 am, [EMAIL PROTECTED] (Jenda Krynicky) wrote:
> From: Northstardomus <[EMAIL PROTECTED]>
>
> > ...
> > $dbh->prepare('INSERT INTO area_status (areaID, survey_date,
> > update_time, status ) VALUES (?,?,?,?)');
> > $dbh->execute('$values[0]', '$values[1]', '$values[2]',
> > '$values[3]');
>
> Apart from the $sth already explained by others, there is one more
> problem with this code. It seems you already found it as it is not
> present in the examples you give in the later posts, but I'd like to
> point it out anyway.
>
> You cannot use singlequotes around the $values[x] in the ->execute()
> call. You'd insert not the values in the @values array, but the
> literal dollar, "values", opening square brace, one and closing
> brace. Try
>
> @values = (1,2,3,4);
> print $values[1], "\n";
> print '$values[1]', "\n";
>
> Just for reference, you should not use doublequotes around them
> either:
>
> $dbh->execute("$values[0]", "$values[1]", "$values[2]",
> "$values[3]");
>
> While this would work (in this case) it forces perl to make copies of
> the values and possibly also an unnecessary number->string
> conversion. I only mention this because I see things like this quite
> often.
>
> Jenda
> ===== [EMAIL PROTECTED] ===http://Jenda.Krynicky.cz=====
> When it comes to wine, women and song, wizards are allowed
> to get drunk and croon as much as they like.
> -- Terry Pratchett in Sourcery
Yes, I found that after looking at my database contents!
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
