Mattm Report post Posted 08/01/2005 04:36 PM I am creating an ordering system and at the end of the order I would like it to repeat the entire order, item by item back to the person making the order. I would like to use the Query Module to select all items with the specific order number and have those read back to the customer.To my understanding you have to reference the specific cell of the returned query results in order to have it read back. How can I have all the items read when the total count of the individual items ordered is dynamic? I am aware of the ModuleTitle_RowCount is there anyway to use that in order to have all records read. Share this post Link to post
SupportTeam Report post Posted 08/01/2005 11:42 PM You would just go through the itmes ModuleTitle_RowCount number of times... Ther is an example of setting up a counter within a loop in the Help file: http://www.voiceguide.com/vghelp/html/modEvalExpr.htm Share this post Link to post
Mattm Report post Posted 08/02/2005 04:41 PM I have a query module that returns the items ordered. Results like: Book Car Shelf How within the Play Sound File module do I reference the result if I dont know many their will be? I saw the example of the function but I want variables I can use in the TTS Will the function provide all of these? If so could you provide an example of how? ie: (TTS) You Have ordered $RV[Query_1_1], $RV[Query_1_2], all the way through to the last item. Share this post Link to post
SupportTeam Report post Posted 08/02/2005 11:16 PM How within the Play Sound File module do I reference the result if I dont know many their will be? The ModuleTitle_RowCount stores how many results they are - then you setup a loop to play the returned results one by one until the ModuleTitle_RowCount number is reached. There is an example of setting up a counter within a loop in the Help file: http://www.voiceguide.com/vghelp/html/modEvalExpr.htm Every time you go through a loop just add an extra check to see if the current counter is still <= to ModuleTitle_RowCount... Share this post Link to post
Mattm Report post Posted 08/03/2005 04:23 PM I used this in a VbScript and then had TTS and an email use $RV[TotalOrder]. RV[OrderSummary_1_i] and RV[OrderSummary_2_i] are item and quantity fields. Dim i set vg = CreateObject("VoiceGuide.CommandLink") for i = 1 to $RV[OrderSummary_RowCount] sRvToRetreive ="RV[OrderSummary_1_" & i & "]" sQtyToRetreive = "RV[OrderSummary_2_" & i & "]" sReturnValue =vbCrLf & vg.RvGet($RV_LINEID, sQtyToRetreive)& " " & vg.RvGet($RV_LINEID, sRvToRetreive) & vbCrLf & sReturnValue next vg.Run_ResultReturn $RV_LINEID, "[TotalOrder]{"& sReturnValue &"}" I dont think I was clear in my phrasing of the original question. Share this post Link to post
SupportTeam Report post Posted 08/04/2005 02:01 AM OK, so when this VBScript finishes running the contents of $RV[TotalOrder] would be something like this: 5 Book 1 Car 2 Shelf Have you tried just specifying $RV[TotalOrder] in the Play module's Text To Speak field? You may need to remove the vbCrLf's from your string in order for it to be spoken properly. Share this post Link to post