Tts Reading Result From Query

[XOLimited]

Hi there,

 

We currently have a script that retrives text from an SQL 2005 database - When entering the RV in the 'text to speak:' field of a Play Sound module, the TTS engine fails to play the data.

 

Is there a way of solving this,

 

Thanks

 

Tim

[SupportTeam]

Enable logging by setting the log levels to 10 in VG.INI as per below:

[Log]

 

VoiceGuide=10

NumberLoader=0

VoicemailManager=0

EmailSender=0

TapiWrapOcx=10

SapiWrapOcx=10

Then restart VG and make a test call which demonstrates the problem.

 

Debug Trace files will be created in VG's \log\ subdirectory.

 

Please post the traces and the VoiceGuide script used.

 

When posting traces/scripts please .ZIP them up and post them as attachments.

[XOLimited]

Thanks

 

File attached

 

Tim

1020sw.zip

[SupportTeam]

Trace shows that database query in module [userID-Lookup] returned one result row:

104209.41 0 state [userID-Lookup] DB Query

104209.41 0 db ODBC mode used

104209.64 0 db About to execute a Retrieve type operation [select firstname from [user] where UserID = 56]

104209.64 0 db [userID-Lookup] row count=1

104209.64 0 rv lg add [userID-Lookup_RowCount]{1}

but then in module [Play 9] the script is told to play $RV[userID-Lookup]

 

$RV[userID-Lookup] is not a valid RV.

 

You should be using:

 

$RV[userID-Lookup_1_1]

 

( $RV[userID-Lookup_1] will work as well I think ).

 

See the Help file section of DBQuery module to see what RVs are created by that module: http://www.voiceguide.com/vghelp/html/modDbQuery.htm