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 TName] , DisplayName] , Title] , Department] , Email] , FirstName] , LastName] , Description] , Phone] , Mobile] , DistinguishedName] , Street] , City] , Country] , State] , Company] , Office] , PostCode] FROM M_TempTable3] WHERE RowNum BETWEEN (1 - 1) * 100 1 AND 1 * 100 ORDER BY YDisplayName] 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.
