> Halo Christian, > $sqls is the object returned by the prepare() method, as in: > > my $sqls = $dbh->prepare( "insert into table $table ( userNumber, > lastName) values ( ?, ?)" ); > > $sqls->bind_param(1, $user_nummer); > $sqls->bind_param(2, $nachname); > > but, if i understand your last message correctly, the problem is with > only the timestamp variable, that you are setting? > > >
Hello Louis, yes i seems to be so. I tried it with differnt versions. Now this is where I stand: $arg1 = $cookieValue; $arg2 = $dbh->quote ( $ueberschrift ) . "::text"; $arg3 = $dbh->quote ( $beschreibung ) . "::text"; $arg4 = $dbh->quote ( $system_zeit ) . "::timestamp"; $arg5 = $dbh->quote ( "2001-11-11 11:11:11" ) . "::timestamp"; $arg6 = $startpreis; $arg7 = $startpreis; $arg8 = $kategorie_nummer; $result = $dbh->prepare ( "SELECT neue_auktion ( ?, ?, ?, ?, ?, ?, ?, ? ) " ) 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(); And now I get this error again, that the argument 'startzeit' (english start-time) is of type timestamp without time zone but the expression has the type text. "Hint: you should make a typecast", but this is what I'm doing all the time. Gruss Christian -- Telefonieren Sie schon oder sparen Sie noch? NEU: GMX Phone_Flat http://www.gmx.net/de/go/telefonie