[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: RE: Dialog box, passing parameter fails
From: "Voillequin, Jean-Marc" <Jean-Marc.Voillequin () moodys ! com>
Date: 2019-09-23 6:53:17
Message-ID: BYAPR20MB2614E42280AA8AF5F10D1E8DBE850 () BYAPR20MB2614 ! namprd20 ! prod ! outlook ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Hi,
Use $1, $2, … for bind parameters.
Regards
From: intmail01@gmail.com <intmail01@gmail.com>
Sent: Saturday, September 21, 2019 12:21 AM
To: pgsql-sql@lists.postgresql.org
Subject: Dialog box, passing parameter fails
Importance: High
CAUTION: This email originated from outside of Moody's. Do not click links or open \
attachments unless you recognize the sender and know the content is safe.
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
-----------------------------------------
Moody's monitors email communications through its networks for regulatory compliance \
purposes and to protect its customers, employees and business and where allowed to do \
so by applicable law. The information contained in this e-mail message, and any \
attachment thereto, is confidential and may not be disclosed without our express \
permission. If you are not the intended recipient or an employee or agent responsible \
for delivering this message to the intended recipient, you are hereby notified that \
you have received this message in error and that any review, dissemination, \
distribution or copying of this message, or any attachment thereto, in whole or in \
part, is strictly prohibited. If you have received this message in error, please \
immediately notify us by telephone, fax or e-mail and delete the message and all of \
its attachments. Every effort is made to keep our network free from viruses. You \
should, however, review this e-mail message, as well as any attachment thereto, for \
viruses. We take no responsibility and have no liability for any computer virus which \
may be transferred via this e-mail message.
This email was sent to you by Moody's Investors Service EMEA Limited
Registered office address:
One Canada Square
Canary Wharf
London, E14 5FA
Registered in England and Wales No: 8922701
-----------------------------------------
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Use $1, $2, … for bind \
parameters.<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:windowtext"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
style="color:windowtext">Regards<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="color:windowtext"><o:p> </o:p></span></p> <div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="color:windowtext">From:</span></b><span \
style="color:windowtext"> intmail01@gmail.com <intmail01@gmail.com> <br>
<b>Sent:</b> Saturday, September 21, 2019 12:21 AM<br>
<b>To:</b> pgsql-sql@lists.postgresql.org<br>
<b>Subject:</b> Dialog box, passing parameter fails<br>
<b>Importance:</b> High<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p> <p \
class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:12.0pt;background:#FFEB9C">
<strong><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:#9C6500">CAUTION:</span></strong><span \
style="font-size:10.0pt"> This email originated from outside of Moody's. Do not click \
links or open attachments unless you recognize the sender and know the content is \
safe.</span><o:p></o:p></p> <p class="MsoNormal" \
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span \
style="color:windowtext"> </span><o:p></o:p></p> <div>
<p>Hi, I am using Postgresql 9.5 as server and Libreoffice BASE 5.2.4 to connect to \
the server.<o:p></o:p></p> <p>The code SQL must be sent directly and not be \
interpreted by Libo Base because there are some complex syntax (functions, variables, \
...).<o:p></o:p></p> <p>Also, I need passing parameters to control some ranges. \
ex: dates.<o:p></o:p></p> <p>But, postgresql can not understand passing \
parameters with either ? or : syntax which open a dialog box.<o:p></o:p></p> <p>eg: \
select * from agenda where date= ?<o:p></o:p></p> <p>The execution of code ode fails \
in direct mode.<o:p></o:p></p> <p>What are solutions ? cant postgresql bypass some \
parts of the code where I put parameters request ?<o:p></o:p></p> <p>Thank \
you<o:p></o:p></p> </div>
</div>
<div>-----------------------------------------<div>Moody's monitors email \
communications through its networks for regulatory compliance purposes and to protect \
its customers, employees and business and where allowed to do so by applicable law. \
The information contained in this e-mail message, and any attachment thereto, is \
confidential and may not be disclosed without our express permission. If you are not \
the intended recipient or an employee or agent responsible for delivering this \
message to the intended recipient, you are hereby notified that you have received \
this message in error and that any review, dissemination, distribution or copying of \
this message, or any attachment thereto, in whole or in part, is strictly prohibited. \
If you have received this message in error, please immediately notify us by \
telephone, fax or e-mail and delete the message and all of its attachments. Every \
effort is made to keep our network free from viruses. You should, however, review \
this e-mail message, as well as any attachment thereto, for viruses. We take no \
responsibility and have no liability for any computer virus which may be transferred \
via this e-mail message. <br><br>This email was sent to you by Moody's Investors \
Service EMEA Limited<br>Registered office address:<br>One Canada Square<br>Canary \
Wharf<br>London, E14 5FA<br>Registered in England and Wales No: \
8922701<div>-----------------------------------------</div></div></div></body> \
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic