Db Navigation Based On Query Results

[Guest Guest_Phillip]

I am using the latest version of VG 4 line enterprise (registered) on win 2000 Pro with dialogic D4PCI.

 

I need to have script that will search a database and then offer to retrieve more information based on the query results. Here is an example of what I’m looking for.

 

For this example, the access table contains these fields:

Address - Street name - Tax information

 

The caller is prompted to enter the address for a property to retrieve more information. The query could return numerous records.

 

Example access table:

1212 Main Street Lot 7 block 4 western meadows sub div etc.

1212 5Th street Lot 4 block 2 High acres sub div etc

1212 4th Street Lot 1 block 2 lowman sub div etc

1212 Moon Street Lot 1 block 2 east meadows sub div etc

1212 Golden Hills Lot 2 block 8 meadowbrook sub div etc

1212 Sky view Lot 5 block 2 Tsunami sub div etc

And so on….

 

I would like to have the system read the results (field 1 & 2) and allow the caller to retrieve additional information based on the query results.

 

Example using TTS

For 1212 Main Street press 1

For 1212 75th street press 2

For 1212 4th Street Press 3

For 1212 Moon St Press 4

For 1212 Golden Hills Press 5

For 1212 Long view press 6

For 1212 Bunker press 7

For 1212 Mocho vie press 8

For 1212 Palisades press 9

For more properties press 0

To return to the mail menu Press *

 

Could you point me in the direction of a previous post or other information to accomplish this? Also, what can I do in the event that there are more than 10 results?

[SupportTeam]

You just play the Text To Speech generated file "For 1212 Main Street press 1 ... etc" and based on user response play another TTS file which is generated using the index number that the caller entered.

 

For example if the user enters 4 then the "Lot 1 block 2 east meadows sub div ... etc" information would be available to you using the $RV[GetInfo_X_4] series of Result Variables. The exact naming of the RV's depends on how you structure your SQL query.

 

what can I do in the event that there are more than 10 results

Ask give callers a 2 digit number to enter.

If playing the sound files form a "Play" module then you should use another Play or Get Numbers module to get the second number and then use the RV's from both modules to get both the digits entered by caller.

[Guest Guest_Phillip]

I missed the basic part. From the first quiery results,

How do I populate the choices…

 

For 1212 Main Street press 1

For 1212 75th street press 2

For 1212 4th Street Press 3

For 1212 Moon St Press 4

For 1212 Golden Hills Press 5

For 1212 Long view press 6

For 1212 Bunker press 7

Etc.

 

on the fly from the query response?

 

How do I move to the next set of 10 records, if they exist?

 

Thanks

[SupportTeam]

Please post the script within which you are right now retrieving the Address/Street/Tax information.

 

We can then post an example relating directly to your script.