How to save input values into SQL Server 2005

[kishore.inline]

Hi

Thanks for your support

I have written xml code for my IVR, but I want to save the inputs of the dialer into database.

Example if the dialer enter clientID and I should validate clientid against DB. If the clientID exists then I should save the clientID and timestamp(dialler called time) into db.

How can I achieve this.

with regards
Kishore

[support]

Hi,

If you're looking to integrate your VoiceXML application with a back-end database, you would want to pass the variables for ClientID, etc. to a PHP page, and then use PHP's built-in mssql functions to interact with the database and your input data.

In general, however, this is more of a database question, whereas we try to stick to VoiceXML in this forum.

Hope this helps.

Regards,
Plum Support

[kishore.inline]

I want to the logic, how your values are saved into DB, which are inputed trough the telephone dial pad

[kishore.inline]

If I want to save the values into DB, is PHP is the only way, or there any other ways in your plum

[support]

Hi,

The best way to save values to a DB that were input through the dial pad is to collect those values as variables in your VXML code, and then pass those variables to another page (you could use PHP, ASP, etc.) where you can do all the DB interaction. Subsequently, you can pass variables back to your VXML code if needed.

Regards,
Plum Support