On Wed, Nov 12, 2008 at 7:26 PM, Dr.Ruud <[EMAIL PROTECTED]> wrote:
> "Jeffrey Seger" schreef:
>
>> Are you using do() instead of prepare()? Placeholders go into with
>> prepared statements, not immediate executions.
>
> See the DBI documentation:
>
> "do"
> $rows = $dbh->do($statement) or die $dbh->errstr;
> $rows = $dbh->do($statement, \%attr) or die $dbh->errstr;
> $rows = $dbh->do($statement, \%attr, @bind_values) or die ...
>
> Prepare and execute a single statement. [...]
Right you are....I wasn't paying attention to the fact that it was an insert....
The "do()" method can be used for non repeated non-"SELECT" statement
(or with drivers that don't support placeholders):
Bruce:
Can we see the actual code that is producing the error? Without that
we'll just have to keep guessing.
>
> --
> Affijn, Ruud
>
> "Gewoon is een tijger."
>
--
They who would give up an essential liberty for temporary security,
deserve neither liberty or security.
Benjamin Franklin
Our lives begin to end the day we become silent about things that matter.
Martin Luther King
The right of the people to be secure in their persons, houses, papers,
and effects, against unreasonable searches and seizures, shall not be
violated, and no warrants shall issue, but upon probable cause,
supported by oath or affirmation, and particularly describing the
place to be searched, and the persons or things to be seized.
Amendment IV to the Constitution of the United States
"I am not going to answer any questions as to my association, my
philosophical or religious beliefs or my political beliefs, or how I
voted in any election, or any of these private affairs. I think these
are very improper questions for any American to be asked, especially
under such compulsion as this."
Pete Seeger before the House Un-American Activities Comittee
