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...
