Hello,
I need to select, update and insert data into my web database.
I need 3 VB Script do these for me.
Over view of the project:
The IVR script is located in local computer. I use [login to view URL] to build my IVR.
1. When IVR received a call, it will get a caller ID of caller.
2. Then my IVR will pass the caller ID to VB Script.
3. When the VB Script runs by IVR script, it will connect to web database and select, update, and insert data into the web database where the caller ID is matched.
4. Then VB script will assign the result in variable(s) that my IVR can read them.
Here is and example how the VB Script should works for “Select?? code.
1. The VB Script will get the Caller ID that passed to it from my IVR script. For example:
Dim CalID
CalID = 5552226666
2. The VB Script should connect to my host, ( the address, User name, and password will be provided to you)
3. Select every field that is in the raw of the caller ID 5552226666.
4. then the VB script will assign each selected field into the new variable. For example: comName, clnName, AptD, AptT are the variable that will hold the result of company Name, Clint Name, Appointment Date, and Appointment Time. I will provide access database to you. In this file you will see all the fields.
The update and insert code should works the same. Let me know if you have any question.