assigning SQL date/time value to variable in IVR script
I am trying to pull a sql date/time value from a Microsoft SQL 2000 database and assign the value to a local variable in an IP IVR script. I have tried creating both Date and Time variables however when I try to assign the value with DB Get Resource neither one shows up in the drop down menu in CCX script editor. Do I need to do some data conversion with constructors or such? Basically what I am trying to do is compare the current date and time to a date and time stored in a database.
Re: assigning SQL date/time value to variable in IVR script
I figured out the problem. For those who want to know, when in UCCX Editor you can click on Add New Variable. When the pop up box appears select any of the available variable types in the list. We will change this in a moment. Once you have selected a variable type it will be highlighed in blue. Go ahead and type in the type of variable you need, in my case it was a java.sql.Timestamp. I then named it databaseDate and left it at the default value. Now when i do a database dip I can directly assign the value from the database to the newly created java.sql.Timestamp variable databaseDate. To compare my database date to the current date I created a new variable of type Date and called it currentDate with a value of new Date(). You can do a direct comparison of type Date with java.sql.Timestamp such as "if (currentDate <= databaseData). Hope this helps.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...