Symptoms
People picker control not accepting active directory display names that have apostrophes
Diagnoses
We have people picker controls that will populate names with apostrophes and then save them. However, when the data loads we receive an error and it will not display the data.
Error message:
Incorrect syntax near 'Rourke'. Unclosed quotation mark after the character string ') SELECT [Name] ,[DisplayName] ,[Title] ,[Department] ,[Email] ,[FirstName] ,[LastName] ,[Description] ,[Phone] ,[Mobile] ,[DistinguishedName] ,[Street] ,[City] ,[Country] ,[State] ,[Company] ,[Office] ,[PostCode] FROM [_TempTable3] WHERE RowNum BETWEEN (1 - 1) * 100 1 AND 1 * 100 ORDER BY [DisplayName] ASC Set @ReturnCountBroker = @@RowCount'.
•Type: SourceCode.SmartObjects.Client.SmartObjectException
•Source: SourceCode.SmartObjects.Client
•Method Base
◦Member Type: Method
◦Name: GetSmartObjectReader
◦Module
◾Scope Name: SourceCode.SmartObjects.Client.dll
◦Declaring Type
◾Full Name: SourceCode.SmartObjects.Client.SmartObjectClientServer
•Stack Trace:
at SourceCode.SmartObjects.Client.SmartObjectClientServer.GetSmartObjectReader(SmartObject smartObject, ExecuteListReaderOptions options, Dictionary`2and propertyReference)
at SourceCode.SmartObjects.Client.SmartObjectClientServer.ExecuteListReader(SmartObject smartObject, ExecuteListReaderOptions options)
at SourceCode.Forms.AppFramework.FormsApiToXml.ToXmlList()
at SourceCode.Forms.AppFramework.FormRuntime.SmartObjectExecution(XPathNavigator nav, Boolean outputDependencies, SmartObjectClientServer svr)
at SourceCode.Forms.AppFramework.FormRuntime.WorkXmlToApi(String xml)
at SourceCode.Forms.Runtime.AJAXCall.ProcessRequest(HttpContext context)
Resolution
Known issue, fixed in 4.6.9.
A Cold Fix is available.