Interact With Database

[SupportTeam]

Gianluca M wrote:

 

Hi, i'm tring ivr demo, and i am happy to meet it, i would like more about database interact and in wich mode response of a query must analize:

1)if my query do not match any record, in wich mode i can analyze "_RowCount " variable and decide what can i do ?

2)when a select return a value, can i decide what can i do base on it's value (eg. if 1 goto ...., else if 2.....else.....) ?

3)when a select return more than one record, can i manipulate this "record set" ?

 

Thank's in advance, i think that i will buy it .....

 

By By.

Gianluca M

[SupportTeam]

You can use the "Evaluate Expression" module to check for value of _RowCount variable, or the various results..

 

you can use a counter to cycle through the rows:

 

$RV[LookupTelFax_1_$RV[counter]]

 

The counter would also be incremented in the Evaluate Expression modules...

 

 

From VoiceGuide Help file:

 

ModuleTitle_ColumnIndex_RowIndex

 

If more then one item was requested in the query, the Column Index can be used to access the individual items in each retrieved row.

 

eg: module LookupTelFax uses a query:

SELECT Tel, Fax FROM Customer WHERE CustId='$RV[Get CustId]'

We can use LookupTelFax_1_1 to access the contents of the Tel column and use LookupTelFax_2_1 to access he contents of the Fax column for customer 1. We can use LookupTelFax_1_2 to access the contents of the Tel column for customer 2, etc.

 

ModuleTitle_RowCount

 

Will return the number of entries which were returned.