I'm glad it worked. However I'm still concerned with why you need the nonportable form of ??::text etc.
Is this because you are running a user defined function which has no schema associated with it the way a regular table or view would? Is there some way to make it more portable, i.e. not needing to specify explicit types for columns? -Will -----Original Message----- From: Christian Stalp [mailto:[EMAIL PROTECTED] Sent: Thursday 23 February 2006 17:46 To: [email protected] Subject: RE: Calling a PostgreSQL function via DBI That the way: $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, ?::numeric, ?::numeric, ?::numeric ) " ) 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(); This works, it writes into the database. Hurra, yea :-))))) Gruss Christian -- DSL-Aktion wegen großer Nachfrage bis 28.2.2006 verlängert: GMX DSL-Flatrate 1 Jahr kostenlos* http://www.gmx.net/de/go/dsl - - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - - This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.
