AXLSQL Update line display getting error

Unanswered Question
Oct 5th, 2009
User Badges:

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>

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Actions

This Discussion