From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=unavailable autolearn_force=no version=3.4.4 Path: eternal-september.org!reader01.eternal-september.org!feeder.eternal-september.org!paganini.bofh.team!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail NNTP-Posting-Date: Mon, 26 Nov 2018 18:27:28 -0600 From: Dennis Lee Bieber Newsgroups: comp.lang.ada Subject: Re: Prepared_Statement :( Date: Mon, 26 Nov 2018 19:27:27 -0500 Organization: IISS Elusive Unicorn Message-ID: <8d3pvdt79sessg38k2uo5s6lqr6u7m61p7@4ax.com> References: <9468b0a5-19bd-4057-a0d8-f84ed0425188@googlegroups.com> User-Agent: ForteAgent/8.00.32.1272 X-No-Archive: YES MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Usenet-Provider: http://www.giganews.com X-Trace: sv3-Bdyt6nXU/aHVCtnzH5me1XWs1iXLneAYX4zOEpt03Y+sAkBGw7pZ19z2L/TnUwdu+HEh4JcJTHv/Epe!96hyeo2NsiQvXLa9lfYodWKNY3aXW2w0q7WVEpLhJryGNEGwjgyQQ+XOPpdoeaI6idaaSzvm X-Complaints-To: abuse@giganews.com X-DMCA-Notifications: http://www.giganews.com/info/dmca.html X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.40 X-Original-Bytes: 2386 Xref: reader01.eternal-september.org comp.lang.ada:54907 Date: 2018-11-26T19:27:27-05:00 List-Id: On Sun, 25 Nov 2018 22:52:49 -0800 (PST), eduardsapotski@gmail.com declaimed the following: >> "?" is how sqlite represents parameters. Postgresql uses $1, $2,... So the >> https://www.postgresql.org/docs/10/sql-prepare.html >Thenks! It really works! >I did as in JDBC. It uses exactly '?'. JDBC is its own database interface. Parameter identifiers are specific to the interface package in use. For a comparison, Python DB-API compatible database adapters can use any of five parameter: ? (replacement in order arguments provided) :# (numbered position) :name (actual parameter name) %s (C printf format codes, %s in Python works for anything) %(name)s (as above, but with parameter name to select) One has to read the documentation for the specific adapter to know which to use (or put in a lot of overhead code to query the adapter for the "paramstyle" and then algorithmically generate statements using the proper style). -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/