Query Database

[Guest Adam]

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.

[Guest Adam]

PLEASE HELP ME!

[SupportTeam]

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

[Guest Adam]

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