I am attempting to create a new record and append new information stored in a variable to a table. I am able to get the script to do a static string but it will not use the value of the string variable I have setup.
user calls in and inputs their phone number.
script places the number in a variable called PhoneNumber
The DBwrite step attempts to upload and create a new record to table with the phonenumber field populated by the value in the variable PhoneNumber.
INSERT INTO tivr_test (phonenumber) VALUES ('PhoneNumber')
Its the oddest thing. After I originally posted this I did use the
$PhoneNumber statement and it still did not work. I then read somewhere that
IPCC and SQL handle string variables differently and that I would need
to convert the string to and integer in order to do this. I did this but neglected to
change the SQL statement to use the int variable.
I tested and was able to write the string to the table. It wasnt until I checked the SQL statement that I realized that i was writing a string to the database. I am still investigating why it is now working.
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...