Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » PostgreSQL: Escape "?" parameter placeholder
PostgreSQL: Escape "?" parameter placeholder [message #52526] Thu, 17 October 2019 12:26 Go to next message
fermium is currently offline  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 Go to previous messageGo to next message
mirek is currently offline  mirek
Messages: 13984
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
Re: PostgreSQL: Escape "?" parameter placeholder [message #52848 is a reply to message #52820] Wed, 11 December 2019 11:24 Go to previous message
fermium is currently offline  fermium
Messages: 8
Registered: October 2018
Promising Member
Thank you!
Previous Topic: BUGFIX: MySqlConnection::SetParam(): handling INT64_V is missing
Next Topic: Soci developer leaving
Goto Forum:
  


Current Time: Sun Jun 16 08:46:14 CEST 2024

Total time taken to generate the page: 0.02389 seconds