Daniel Käfer schrieb: > Hello, > > I use a postgres database and try to make a query with a (PLPG) SQL > function in OOo Base. This query needs two parameters: begin_date and > end_date. > > SELECT * FROM f_termine_report( '{1010131}', :begin_date, :end_date > ,true, true, true, true) > > But no dialog for the parameters opens. The name of the parameters are > replaced with an empty string. Without the parameters it works perfect.
I use this with mysql SELECT * FROM table WHERE Datum >= :Anfangsdatum AND Datum" <= :Enddatum therefore i double the date column Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## http://de.openoffice.org ## Ansprechpartnerin für die deutschsprachige QA ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org