Re: Prepared_Statement :(

[Dennis Lee Bieber <wlfraed@ix.netcom.com>]

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/