philwes83170
MIS
I have a script that writes values to a SQL Database. Unfortunately some of the data contains single quotes in the name (ie. Mom and Pop's Food). I can't seem to get the right combination of quotes to to get this to work. Here is the code that works great for a simple name (ie. Northern Food). Just need to figure out how to make it work if the value contains a single quote. Thanks in advance for any help you can offer.
iReturn = slapi_DBExecuteSQL("UPDATE ACCOUNT SET ACCOUNT = '" & strAccount & "' WHERE ACCOUNTID = '" & strAccountID & "'")
The variable strAccount is the one that is giving me trouble.
iReturn = slapi_DBExecuteSQL("UPDATE ACCOUNT SET ACCOUNT = '" & strAccount & "' WHERE ACCOUNTID = '" & strAccountID & "'")
The variable strAccount is the one that is giving me trouble.