Cisco ICM Script Find NULL

September 9, 2008

So, I ran into an strange problems today. I have a MS SQL database column which contains some NULL values. So, I wanted the calls with a NULL value to go in one direction while the calls without a NULL value to go another. Inside a IF NODE I tried:

Variable = “” or Variable = ” ” or Variable = “NULL” or Variable = NULL

None of those worked. At the end just putting the Variable by itself inside the IF node worked. I guess it makes sense, but when dealing with NULL values it can be tricky at times and behavior might vary.

~david

tags: ,
posted in Cisco by dmacias

Follow comments via the RSS Feed | Leave a comment | Trackback URL

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org