Guest Guest_zackrspv Report post Posted 02/18/2004 10:33 PM Hello. We are having a slight problem looking up data in a Microsoft Access Database. I have attached the Debug Log so that you may see what the problem is. Here is what we have it doing: 1. Customer hears main menu. 2. Customer Selects [11] to goto doctor menu 3. Customer Selects [1] to register 4. ---Caller ID is taken-- 5. If caller ID is not known then it transfers them to the caller id enter section 6. Customer Creates a PIN Number 7. Customer Enters their Subject Choice 8. Database query to resolve subject # to subject Name 9. Database insert to place customer name, phone number, pin, subject, and date/time into the database. 10. Database query to lookup customer authentication number -----This is where we are having the problem. We currently have the system doing this: Select Phone, Pkey from Customer where Phone='$RV_CIDNUMBER' This is susposed to return the following information; the Phone and the PKey associated with the phone number. Now in the database Pkey is a AutoNumber field and is the primary key. When playback happens, we use the Say Number module to play back the $RV[CANumberLookup_2_1] variable which is susposed to return the Pkey value as the client authentication number; however this only returns a blank space; and when using $RV[CANumberLookup_1_2] or _1_1 or _2_2 nothing works. Wonder why? 142520.23 9 linedevstate 2048 0 0 142520.23 9 callstate OFFERING 65896 0 4 142520.24 9 Lev_CallerID [5418998788,COPPER CAULDRON] 142520.26 9 callinfo CALLEDID 142520.26 9 callinfo ORIGIN 142520.26 9 ring 0 142520.26 9 Could not obtain handle to kill process. (new call) 3204, 0 142520.26 9 Answer the call at 2/18/2004 2:25:20 PM 142520.26 9 lineAnswer(65896) => 65930 142520.79 9 callstate CONNECTED 65896,1,0 142520.80 9 WorkingModeTAPI@Connected= 142520.80 9 WorkingModeScript@Connected= 142520.82 9 Inband detection not enabled 142520.82 9 StartLoadedVgs at 2/18/2004 2:25:20 PM 142520.82 9 tapi Reply (LineEvReply) ok 65930 0 142520.82 9 [Main 2] Number Input 142520.82 9 [Main 2] Playing (C:\Documents and Settings\Administrator\My Documents\vgs files\new\mainnew.wav) 142520.84 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\mainnew.wav] 142521.93 9 dtmf 1 (65896,49,2) 142521.93 9 LsGetNbrsPlayWelcMsg 1 142521.98 9 PlaySoundStop ok 142521.98 9 [Main 2] Number Input 1 142521.98 9 path {1} not found 142522.13 9 dtmf 1 (65896,49,2) 142522.13 9 LsGetNbrsRxDigits 1 142522.13 9 [Main 2] Number Input 11 142522.13 9 [DoctorMenu] Playing 142522.13 9 [DoctorMenu] Playing (C:\Documents and Settings\Administrator\My Documents\vgs files\new\doctormenu.wav) 142522.15 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\doctormenu.wav] 142522.15 9 RunModule PLAY end 142522.43 9 dtmf 1 (65896,49,2) 142522.43 9 LsPlayMsg 1 142522.48 9 PlaySoundStop ok 142522.48 9 [MakePin] Playing 142522.49 9 [MakePin] Playing (C:\Documents and Settings\Administrator\My Documents\vgs files\new\pininformation.wav) 142522.49 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\pininformation.wav] 142522.49 9 RunModule PLAY end 142541.13 9 Play End line[9] (id=820406) 142541.13 9 LsPlayMsg EV_PLAY_FINISHED 142541.13 9 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE 142541.13 9 [NoPhone?] Evaluate ["$RV_CIDNUMBER" = ""] 142541.13 9 RVreplace start: ["$RV_CIDNUMBER" = ""] 142541.13 9 RVreplace end: ["5418998788" = ""] 142541.15 9 .Eval(Cstr("5418998788" = "")) 142541.15 9 Eval Expr result:[False] 142541.15 9 [Makepin2] Number Input 142541.15 9 [Makepin2] Playing (C:\Documents and Settings\Administrator\My Documents\vgs files\new\getpin.wav) 142541.15 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\getpin.wav] 142543.60 9 dtmf 1 (65896,49,2) 142543.62 9 LsGetNbrsPlayWelcMsg 1 142543.66 9 PlaySoundStop ok 142543.66 9 [Makepin2] Number Input 1 142543.66 9 path {1} not found 142543.80 9 dtmf # (65896,35,2) 142543.80 9 LsGetNbrsRxDigits # 142543.80 9 fn PlaySoundStartNumbers C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmIntro.wav, C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmMenu.wav, 1, Digits 142543.80 9 sVbsFunctionToUse=Digits 142543.85 9 Started SayNumber VBScript OK. (C:\Program Files\VoiceGuide\data\vbs_9_SayNumber.vbs) 142543.91 9 cl Play_Start C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmIntro.wav,1.wav,C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmMenu.wav 142543.93 9 PlaySoundStart ok [C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmIntro.wav,C:\Program Files\VoiceGuide\system\voice\1.wav,C:\Program Files\VoiceGuide\system\voice\GetNbrsConfirmMenu.wav] 142547.85 9 dtmf 1 (65896,49,2) 142547.85 9 LsGetNbrsPlayConfirm 1 142547.91 9 PlaySoundStop ok 142547.91 9 path {1} not found 142547.93 9 [Get Subject] Number Input 142547.93 9 [Get Subject] Playing (C:\Documents and Settings\Administrator\My Documents\vgs files\new\subject.wav) 142547.93 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\subject.wav] 142550.91 9 dtmf 1 (65896,49,2) 142550.91 9 LsGetNbrsPlayWelcMsg 1 142550.98 9 PlaySoundStop ok 142550.98 9 [Get Subject] Number Input 1 142550.98 9 path {1} not found 142551.12 9 dtmf 1 (65896,49,2) 142551.12 9 LsGetNbrsRxDigits 1 142551.12 9 [Get Subject] Number Input 11 142551.12 9 path {11} not found 142551.13 9 path {11} not found 142551.13 9 [subjectResolve] DB Query 142551.13 9 Jet mode used (To use ODBC mode specify ODBC Connect string) 142551.13 9 RVreplace start: [sELECT Subject, Job, Name, Email FROM joblist WHERE Subject='$RV[Get Subject]'] 142551.15 9 RVreplace end: [sELECT Subject, Job, Name, Email FROM joblist WHERE Subject=11] 142551.15 9 About to execute Retrieve Operation [sELECT Subject, Job, Name, Email FROM joblist WHERE Subject=11] 142551.15 9 [subjectResolve] row count=1 142551.15 9 [success] Playing 142551.15 9 tts generate start[ok] 142551.16 9 tts generate end 142551.16 9 [success] Playing (C:\Program Files\VoiceGuide\data\tts9.wav) 142551.20 9 PlaySoundStart ok [C:\Program Files\VoiceGuide\data\tts9.wav] 142551.20 9 RunModule PLAY end 142552.04 9 wb(84909300) 142552.09 9 Play End line[9] (id=849093) 142552.09 9 LsPlayMsg EV_PLAY_FINISHED 142552.09 9 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE 142552.10 9 [DoctorBarbara] DB Query 142552.10 9 Jet mode used (To use ODBC mode specify ODBC Connect string) 142552.10 9 RVreplace start (strlen>100) 142552.10 9 About to execute Action Query 142552.12 9 [CANumberLookup] DB Query 142552.12 9 Jet mode used (To use ODBC mode specify ODBC Connect string) 142552.12 9 RVreplace start: [sELECT Phone, Pkey FROM Customer WHERE Phone=$RV_CIDNUMBER] 142552.12 9 RVreplace end: [sELECT Phone, Pkey FROM Customer WHERE Phone=5418998788] 142552.12 9 About to execute Retrieve Operation [sELECT Phone, Pkey FROM Customer WHERE Phone=5418998788] 142552.13 9 [CANumberLookup] row count=2 142552.15 9 [CANPlay1] Playing 142552.15 9 [CANPlay1] Playing (C:\Documents and Settings\Administrator\My Documents\vgs files\new\canplay1.wav) 142552.15 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\canplay1.wav] 142552.15 9 RunModule PLAY end 142559.32 9 Play End line[9] (id=850062) 142559.34 9 LsPlayMsg EV_PLAY_FINISHED 142559.34 9 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE 142559.35 9 RVreplace start: [$RV[CANumberLookukp_1_1]] 142559.35 9 RVreplace end: [] 142559.35 9 [CANNumberSay] Say numbers: as Digits 142559.35 9 fn PlaySoundStartNumbers C:\Documents and Settings\Administrator\My Documents\vgs files\new\cannumberis.wav, C:\Documents and Settings\Administrator\My Documents\vgs files\new\canrepeate.wav, , Digits 142559.35 9 sVbsFunctionToUse=Digits 142559.38 9 Started SayNumber VBScript OK. (C:\Program Files\VoiceGuide\data\vbs_9_SayNumber.vbs) 142559.46 9 cl Play_Start C:\Documents and Settings\Administrator\My Documents\vgs files\new\cannumberis.wav,,C:\Documents and Settings\Administrator\My Documents\vgs files\new\canrepeate.wav 142559.46 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\cannumberis.wav,C:\Documents and Settings\Administrator\My Documents\vgs files\new\canrepeate.wav] 142605.90 9 Play End line[9] (id=857375) 142605.90 9 LsSayNbrPlay EV_PLAY_FINISHED 142608.07 9 LsSayNbrPlay EV_TIMEOUT_GOTOMODULE 142608.07 9 [LeaveMessage?] Playing 142608.09 9 [LeaveMessage?] Playing (C:\Documents and Settings\Administrator\My Documents\vgs files\new\mesage.wav) 142608.09 9 PlaySoundStart ok [C:\Documents and Settings\Administrator\My Documents\vgs files\new\mesage.wav] 142608.09 9 RunModule PLAY end 142616.77 9 wb(86600000) 142616.82 9 Play End line[9] (id=866000) 142616.82 9 LsPlayMsg EV_PLAY_FINISHED 142617.48 9 callstate DISCONNECTED 65896,0,0 142617.48 9 LsPlayMsgFinished EV_REMOTEPARTY_DISCONNECT 142617.48 9 Hanging up call... 142617.48 9 RecSoundStop ok 142617.49 9 PlaySoundStop ok 142617.49 9 fnHangupCall end 142617.54 9 linedevstate 2048 0 0 142617.54 9 callstate IDLE 65896 0 0 142617.54 9 WorkingMode@Idle= 142617.55 9 tapi Reply (LineEvReply) ok 65862 0 142618.59 9 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE 142618.59 9 ReinitTelephony due to IDLE start 142618.59 9 tapic lineDeallocateCall(MainCall:65896) 0 142618.65 9 lineOpen(9) => 0 142618.65 9 Waiting for a call... 142618.65 9 lineOpen(9)LineHandle=65913 Share this post Link to post
SupportTeam Report post Posted 02/18/2004 10:39 PM We can see from the trace that the SQL Query Select Phone, Pkey from Customer where Phone='$RV_CIDNUMBER' is performed in module [CANumberLookup] but then in the module [CANNumberSay] the Result Variable specified is: $RV[CANumberLookukp_1_1] look at the above RV, there is a spelling mistake there... it should be: $RV[CANumberLookup_1_1] Share this post Link to post
Guest Guest_zackrspv Report post Posted 02/18/2004 10:50 PM Ha! I supose that is deserving stupidity on my part! lol thanks for that! Since the beginning we have about 100 modules in this script and they are adding more every day! lol i supose i should check spelling more closely! Thanks for responding with the Fix! Ha. sometimes i'm so stupid lol Share this post Link to post
SupportTeam Report post Posted 02/18/2004 11:39 PM we have about 100 modules in this script Have you thought about breaking that up into multiple scripts? VG scripts can call other VG scripts as "subscripts" or by just jumping to them.. more info on this is in the Help file. Also v5.1.8 onwards allows you to "search for a module" in the Script Designer - a useful tool when working with large scripts. Share this post Link to post
