cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

Who Me Too'd this topic

UCCX DB Write step "" issue

dcscuba23
Level 1
Level 1

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

Who Me Too'd this topic