Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
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>
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: