| From: | Steve Midgley <steve(dot)midgley(dot)mixrun(at)gmail(dot)com> |
|---|---|
| To: | intmail01(at)gmail(dot)com |
| Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Dialog box, passing parameter fails |
| Date: | 2019-09-23 00:24:13 |
| Message-ID: | CAJexoS+n+kjwdZbuv4-CxYB5DWX7YLnNLHGNmB=xfJsyKdqaaw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, Sep 20, 2019, 8:20 PM intmail01(at)gmail(dot)com <intmail01(at)gmail(dot)com>
wrote:
> Hi, I am using Postgresql 9.5 as server and Libreoffice BASE 5.2.4 to
> connect to the server.
>
> The code SQL must be sent directly and not be interpreted by Libo Base
> because there are some complex syntax (functions, variables, ...).
>
> Also, I need passing parameters to control some ranges. ex: dates.
>
> But, postgresql can not understand passing parameters with either ? or :
> syntax which open a dialog box.
>
> eg: select * from agenda where date= ?
>
> The execution of code ode fails in direct mode.
>
> What are solutions ? cant postgresql bypass some parts of the code where
> I put parameters request ?
>
> Thank you
>
Can you get your sql code to work from psql command line? Seems like maybe
it's just syntax? Send a complete sql statement including parameters that
is failing..
Steve
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jakob.Witczak | 2019-09-23 05:57:19 | AW: German "umlaut insensitive" query |
| Previous Message | intmail01@gmail.com | 2019-09-20 22:20:42 | Dialog box, passing parameter fails |