IPIVR scripting - DB Read/Get

lohjintiam · ‎07-12-2009

Hi all,

I'm facing an issue when using DB Read + DB Get objects in my scripting. DB Read will be extracting a single row from the table while DB Get would assigning the result from DB Read into the variables defined.

However, each time it goes through DB Get, it will branch out to SQL Error branch regardless if multiple variable (acct num, name, addres) is assigned. It will branch out to the Successful branch if only a single variable is assigned (acct num)

FYI, I'm on UCCX 7.0(SR2) Build 99. Anyone faced the same issue?

Also, anyway we can check for NULL values returned by the SQL statement? Seems like the script will terminate when assigning NULL value to a variable.

Thanks!

-JT-

lohjintiam · ‎07-13-2009

Hi all,

We have narrowed down the cause of the problem. The script is terminating because it's unable to assign a NULL value to a string variable in the DB GET step.

Any way to cater for NULL values? Thanks!

-JT-