VoiceGuide IVR Software Main Page
Jump to content

Query Database

Recommended Posts

Hi,

 

I'm new to Interactive Voice Guide. I need some help...

 

I have an Access database called wireless.mdb, and in this database I have a table called 'subscribers'. I want Interactive Voice Guide to run a program if field name 'id' and 'mac' match the information given by the caller. I hope someone can help.

 

Thanks,

Adam.

Share this post


Link to post

You can use a query like this:

 

SELECT id, mac FROM subscribers WHERE id='$RV[GetId]' AND mac='$RV[GetMac]'

 

Where GetId and GetMac are names of VoiceGuide's Get Numbers modules.

 

Then see if the returned number of rows is 0 or 1. If 1 then an entry was found...

 

I'd recommend reading:

the section of the VoiceGuide Help file covering Result Variables,

the section of the VoiceGuide Help file covering Database Query module,

and also buying a book on databases and SQL

Share this post


Link to post

Thank you very much,

 

...your help is much apreciated.

 

I did look at your help files but I was still confused, I will think about buying a book if I wish to do more database work.

 

Thanks, once again.

 

Adam.

Y3000.com

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×