-
Helpful SQL Syntax for e-Work
The information in this article applies to product: e-Work 5.x 6.x Sample SQL * * Incorrect: %ExecSQL("INSERT INTO CMSearchResults (efolderid,BatchID,ci\_searchid,ci\_sindex) VALUES (%FolderID,%BatchNumber,%txtci\_searchid,(SELECT ci\_sindex FROM ci\_searchdetail WHERE (ci\_searchid = %txtci\_searchid)))") Correct:…
-
Error When Uninstalling e-Work 6.2 or Upgrading to 6.5
The information in this article applies to product: e-Work 6.2 Issue * When uninstalling e-Work 6.2 or trying to upgrade to 6.5, the following error message is generated: 'Error 1920. Service W3SVC (W3SVC) failed to start'. Resolution * Install e-Work hotfix 6.2.0.B, available from the Customer and Partner Zones. After…
-
Limitations in the Use of External Forms
The information in this article applies to product: e-Work 5.x 6.x Issue * PDF external forms won't refresh. Resolution * Dependent fields/form refreshes are not supported with external forms. These features are only available with native e-Work forms.
-
e-Work Unable to Retrieve Data from Linked Server
The information in this article applies to product: e-Work 6.x Issue * A customer had e-Work 6.1 installed on a server with SQL Server 2000. A second server running SQL Server 2000 was configured as a linked server on the e-Work server. A view was created in the e-Work database to a table on the linked server. Through…
-
eUserName Populated by samAccountName in Active Directory
The information in this article applies to product: e-Work 6.2 Issue * The e-Work 6.2 Directory Integration Suite Guide states that "Normally the user’s common name in the directory is used as the e-Work user ID." Resolution * This should read "Normally the user’s common name (in eDirectory) or samAccountName (in Active…