cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
4792
Views
23
Helpful
15
Replies
dcscuba23
Beginner

UCCX DB Write step "" issue

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

15 REPLIES 15

So I'm trying to pass a boolean to a 'bit' in SQL. Boolean values are true/false and bit requires either 0/1 or "true"/"false" - note quotes. The issue is that the underlying java references boolean without quotes but SQL expects quotes. Workaround is to do an if on the boolean to either set a char as "\0" or "\1" or a string as "true"/"false" and then pass the char/string to the database.

i.e.

That should be  "  'false'  " - I've added spaces so that you can see both the single quote ' and the double quote ".

Good luck,

     Joe