Hi,
I have below query in my DSS configs. However this fails when values have
spaces or special characters &.
<query id="AddEmployeeTemp" useConfig="allocationDS">
<sql>INSERT INTO
employees(Employee_Id,First_Name,Last_Name,Work_Email,Gender,Job_Role,Department,Reports_To,Product,)
VALUES ( :id,
:firstName,:lastName,:email,:gender,:role,:department,:reportsTo,:product,:team);</sql>
<param name="id" sqlType="STRING"/>
<param name="firstName" sqlType="STRING"/>
<param name="lastName" sqlType="STRING"/>
<param name="email" sqlType="STRING"/>
<param name="role" sqlType="STRING"/>
<param name="gender" sqlType="STRING"/>
<param name="reportsTo" sqlType="STRING"/>
<param name="team" sqlType="STRING"/>
<param name="product" sqlType="STRING"/>
<param name="department" sqlType="STRING"/>
</query>
Problematic values:
department=HUMAN RESOURCES AND ADMINISTRATION, role=Lead - HR &
Administration,
I tried escaping with single quote (':department') and double
quote(":department"), both did not work for me. What modification should
be done to add values with spaces and special characters.
Udara Liyanage
Software Engineer
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware
web: http://udaraliyanage.wordpress.com
phone: +94 71 443 6897
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
