Receive an error attempting to delete a user in Helpdesk Internet edition

Version 1
    Question

    Receive the following error when attempting to delete a user in Helpdesk Internet Edtion.

     

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
    near 'xxxxx'.

    /helpdesk/maintenProcesser.ASP, line 63.”


    Answer

    This is usually returned if the users name has an apostrophe in it such as O'Neil.  Helpdesk Internet edition does not handle the appostrope correctly and forms an invalid SQL statement which fails, returning the syntax error.  A simple workaround is to delete the user within the Helpdesk/SupportCenter thick client rather than Internet edition.

     

    Environment

    Helpdesk/SupportCenter Internet Edition 6.6