Re: Prepared_Statement :(

["Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>]

On 2018-11-27 01:27, Dennis Lee Bieber wrote:
> 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).

Ergo, if you can, never use any DB-specific bindings, use ODBC. It is 
not portable across RDBMs either (SQL is very not Ada (:-)), but at 
least it would give you far less headache...

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de