Kaseya Community

executeSqlQuery Script with Double Quote

This question is not answered

How can I execute something like this using executeSqlQuery script

<queryDef label="Agent Guid" sql="SELECT REPLACE('[$CustomField$]','<a href="','test')" />

The xml file becomes erroneous because of the double quote under '<a href="'.
All Replies
  • <queryDef label="Agent Guid" sql="SELECT REPLACE('[$CustomField$]','<a href="','test'")" />

    Could it be that you missed one double quote;  must always be in pairs of 2