Updating the Display and Ascii Display of the line

Version 1
    This document was generated from CDN thread

    Created by: Manas Varma on 08-12-2009 01:36:50 PM
    Hi ,
        I am trying to update the display and Ascii display  of the line using sql and C#. But i am getting a run time error on the server saying " syntax error in the code " 
       

     This is my code:


    string sql = "update devicenumplanmap set display='Manas' from numplan where numplan.dnorpattern='33899' and   devicenumplanmap.fknumplan=numplan.pkid";
     ExecuteSQLQueryReq _queryRequest = new ExecuteSQLQueryReq();
    _queryRequest.sql = sql;
    ExecuteSQLQueryRes _queryResponse = oAXL.executeSQLQuery(_queryRequest);
     

     
     
    Can you please point out the mistake or else tell me a better way of updating the display and ascii display..
     
    Thanks
    Manas 
     

    Subject: RE: Updating the Display and Ascii Display of the line
    Replied by: sujit pillai on 14-12-2009 06:29:25 AM
    Hi,
     
    By using AXL api updatephone you can change disply and asciidisplay name of phone line.
     

    Subject: RE: Updating the Display and Ascii Display of the line
    Replied by: Frederick Nielsen on 03-08-2010 09:55:44 PM
    Did you ever figure out how to do this?  Trying to do the same, it appears that there is no easy "one-step" way via either SQL or updatePhone to accomplish...