07-16-2012 10:13 AM - edited 03-14-2019 10:13 AM
Hi Guys,
I am running UCCX 8.5. I have identified what the issue is but can’t seem to figure out a way around it. I am doing a simple DB write step to a MSSQL 2005 server. The issue is the query fails when the VALUE is set to a string variable in my script. Since it is a string variable, CCX adds the double quotes around the value. When I run a trace on the SQL DB with SQL profiler, the insert fails because SQL will only accept a value with a single quote. If I change the VALUE in my script to let’s a char variable it works, because CCX populates the char variable value with a single quote and not double… Is there a trick to strip the double quotes off a string variable when trying to pass over to a DB for write steps? Any guidance would be deeply appreciated! Thanks!
Thanks,
Damon