Update Line Display getting syntax error

Version 1
    This document was generated from CDN thread

    Created by: Haresh Khemani on 06-10-2009 01:39:00 AM
    update devicenumplanmap
    set display='WHS Dialysis Isolation Room 2'
    from numplan where numplan.dnorpattern='33722'
    and devicenumplanmap.fknumplan=numplan.pkid
     
    CUCM ver is 6.1.2 and AXL code as follows
     
    <?xml version="1.0" encoding="UTF-8"?>
    <!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
    <!DOCTYPE data [
        <!ELEMENT data (sql+)>
        <!ELEMENT sql EMPTY>
        <!ATTLIST sql
        query CDATA #IMPLIED
        update CDATA #IMPLIED
    >
    ]>
    <data>
    <sql update="update devicenumplanmap set display='WHS Dialysis Isolation Room 2' from numplan where numplan.dnorpattern='33722' and devicenumplanmap.fknumplan=numplan.pkid"/>
    </data>
     
    Getting the following error:
     
    <?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Header/><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Client</faultcode><faultstring>A syntax error has occurred.</faultstring><detail><axl:Error xmlns:axl="http://www.cisco.com/AXL/API/1.0"><axl:code>-201</axl:code><axl:message>A syntax error has occurred.</axl:message><request>executeSQLUpdate</request></axl:Error></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

    Subject: RE: Update Line Display getting syntax error
    Replied by: David Staudt on 06-10-2009 04:01:23 AM
    Not sure how you are generating the XML (XML Spy?), but it doesn't look correct.  <executeSQLUpdate> should look something like:
     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/6.1">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:executeSQLUpdate sequence="1">
             <sql>update devicenumplanmap set display='WHS Dialysis Isolation Room 2' from numplan where numplan.dnorpattern='33722' and devicenumplanmap.fknumplan=numplan.pkid</sql>
          </ns:executeSQLUpdate>
       </soapenv:Body>
    </soapenv:Envelope>

     
    I commonly use a tool called soapUI for generating/testing AXL: http://www.soapui.org/