U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Escape string in MySQL

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

Escape string in MySQL [message #51820]

Sat, 08 June 2019 08:29

forlano
Messages: 1185
Registered: March 2006
Location: Italy

Senior Contributor

Hello,

when executing a sql.Execute() command I have problem if the content of some string has the single quote , ' . Perhaps other characters may give problem. Do we have a method that treat the string preventing error and let the string to be shown correctly?

Thanks,
Luigi

Report message to a moderator

Re: Escape string in MySQL [message #51824 is a reply to message #51820]

Sat, 08 June 2019 17:01

Novo
Messages: 1358
Registered: December 2006

Ultimate Contributor

You shouldn't embed your string into an SQL statement. Use parameters instead. Example (Sqlite):

String oc_name = "Can't do that";	
Sql sel(dbs);
sel.SetStatement("SELECT id FROM lemma WHERE oc_name = ?");
sel.Run(oc_name);

Another useful method to use is Sql::SetParam.

Regards,
Novo

Report message to a moderator

Previous Topic:	postgresql mingw
Next Topic:	Sqlite join from select

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 25 02:16:32 CEST 2024

Total time taken to generate the page: 0.03889 seconds