VoiceGuide IVR Software Main Page
Jump to content

Database Query Stopped Working

Recommended Posts

Hello:

 

I just registerd the program (I'm not sure that this has anything to do with my problem though). I was able to qure database and play info through result variables but now here is waht I'm getting

 

 

97140 0 [DatabaseTest] DB Query

97140 0 Jet mode used (To use ODBC mode specify ODBC Connect string)

97140 0 About to execute Retrieve Operation [select name from personalinfo where amount = 5400]

97140 0 [DatabaseTest] row count=1

97156 0 TimeoutClear

97156 0 [say1] Playing

97156 0 RVreplace start: [$RV[EnterID] $RV[DatabaseTest]]

97156 0 RVreplace end: [123 $RV[DatabaseTest]]

97156 0 tts generate start[123 $RV[DatabaseTest]]

97203 0 tts generate end

97203 0 [say1] Playing (C:\Program Files\VoiceGuide\system\tts0.wav)

97234 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\system\tts0.wav]

97234 0 TimeoutClear

97250 0 RunModule PLAY end

97250 0 wa(2208,69720300)

99453 0 Play End line[0] (id=697203)

99453 0 LsPlayMsg EV_PLAY_FINISHED

99453 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

99453 0 TimeoutSet 10 EV_TIMEOUT_HANGUP

10375 0 Timer fired EV_TIMEOUT_HANGUP

 

 

What is this row count = 1 thing??? I tried couple databases (Interbase via ODBC and Access in Jet mode - same story)

 

Please help

 

Thanks

Share this post


Link to post

"row count=1" means that one database entry matched your select query, ie: your query did retrieve something.

 

I think the problem lies in the Result Variable - you should use $RV[DatabaseTest_1_1] instead of $RV[DatabaseTest]

 

 

Here is a quote from the relevant section of the VoiceGuide Help file:

 

Query Results

 

The results of the database query are accessible using Result Variables. The following Result Variables can be used to access data retrieved by a Db Query module:

 

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. This is mainly used in Microsoft Access SQL queries, as when querying Microsoft Excel we specify how many rows are to be retrieved. More information on SQL queries can be found in MS Access Help file, and in most database manuals.

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
×