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: [email protected]
For additional commands, e-mail: [email protected]
