I'm a Java programmer - so for me, by far the easiest way is to use a custom Action Element in CVP VXML. I actually run a complicated stored procedure (the input is the calling line ID) through the native Microsoft SQL Java driver and get back a structured string which I return to ICM in caller_input. Then I pull it apart using the ICM substring function.
You could also use the built-in Database Element. I'm not a huge fan of it myself, but if you cannot build custom Java elements, it's what you need.
Good work Chad. I have also made that mistake with the ICM set node. Too much work - I hear you.
I have found that the Find tool is a pretty useful check at the end of a lot of scripting. If you choose the right thing for your search, or open up a number of scripts all at once and then search the open scripts, you can normally find a few mistakes where you have built a number of scripts from a prototype that you are then changing slightly. This has helped me a few times.
A REALLY GOOD naming convention can help you contain the silly mistakes, too.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...