Page 1 of 1
Escaping single quotes
Posted: Mon 16 Jul 2012 10:20
by arkajzerek
How single quotes are escaped in case of parameters?
Trying to run simple query as follows:
select id from account where name = @name
@name is set using Parameters.AddWithValue method to "Arek's company"
Thanks.
Re: Escaping single quotes
Posted: Wed 18 Jul 2012 16:39
by Shalex
Here is an example of handling single quotes:
Code: Select all
SalesforceCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from account where type = @type";
cmd.Parameters.AddWithValue("type", "Customers' account");
cmd.Parameters[0].SalesforceType = SalesforceType.String;
SalesforceDataReader reader = cmd.ExecuteReader();
while (reader.Read()) {
Console.WriteLine(reader["Name"]);
}
If the SalesforceType.String type is set explicitly, dotConnect for Salesforce quotes single quote in the query which is sent to the server.