U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSQL: Escape "?" parameter placeholder

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

PostgreSQL: Escape "?" parameter placeholder [message #52526]

Thu, 17 October 2019 12:26

fermium
Messages: 8
Registered: October 2018

Promising Member

Is it possible to escape a character '?' when using Sql class? This character is used as an operator when working with a jsonb type

[Updated on: Thu, 17 October 2019 13:13]

Report message to a moderator

Re: PostgreSQL: Escape "?" parameter placeholder [message #52820 is a reply to message #52526]

Thu, 05 December 2019 19:14

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

This is bit problematic as many SQL databases have '?' in their C interface definition and cannot escape it, so general solution (as for all SQL RDBMs) is impossible.

However, it is my understanding that jsonb type is specific for PGSQL. For this parcular SQL flavor, I have added

void NoQuestionParams(bool b = true);

and also possiblity to escape '?' by "??"

Mirek

Report message to a moderator

Re: PostgreSQL: Escape "?" parameter placeholder [message #52848 is a reply to message #52820]

Wed, 11 December 2019 11:24

fermium
Messages: 8
Registered: October 2018

Promising Member

Thank you!

Report message to a moderator

Previous Topic:	BUGFIX: MySqlConnection::SetParam(): handling INT64_V is missing
Next Topic:	Soci developer leaving

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 16 14:34:23 CEST 2024

Total time taken to generate the page: 0.00853 seconds