> See if this works: > > my $sth = $dbh->prepare(<<"EndOfSQL"); > SELECT neue_auktion ( ?, ?::text, ?::text, > ?::timestamp, ?::timestamp, > ?, ?, ? ) > EndOfSQL > > $sth->execute($cookieValue, $ueberschrift, $beschreibung, > $system_zeit, "2001-11-11 11:11:11", > $startpreis, $startpreis, $kategorie_nummer); > > Ronald
I don't know if this is what you mean, or should I put it in exactly as you wrote? I tried this: $arg1 = $cookieValue; $arg2 = $dbh->quote ( $ueberschrift ); $arg3 = $dbh->quote ( $beschreibung ); $arg4 = $system_zeit; $arg5 = "2001-11-11 11:11:11"; $arg6 = $startpreis; $arg7 = $startpreis; $arg8 = $kategorie_nummer; $result = $dbh->prepare ( "SELECT neue_auktion ( ?, ?::text, ?::text, ?::timestamp, ?::timestamp, ?, ?, ? ) " ) or die "Vorbereitung nicht durchfuehrbar!\n"; $result->bind_param ( 1, $arg1 ); $result->bind_param ( 2, $arg2 ); $result->bind_param ( 3, $arg3 ); $result->bind_param ( 4, $arg4 ); $result->bind_param ( 5, $arg5 ); $result->bind_param ( 6, $arg6 ); $result->bind_param ( 7, $arg7 ); $result->bind_param ( 8, $arg8 ); $result->execute() or die "Abfrage nicht ausfuehrbar -suchprofil! $DBI::errstr\n"; $result->finish(); But its crazy, it has the same result. Still the error-code that the column 'zeitwert' has ... no, one moment its »startpreis«. We are one step further! Gruss Chritian -- Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
