Db Query module gives 'Error 3061'

[Guest developer]

074134.31 0 ApiMode=[TAPI]

074134.31 0 Tapi device 0 is: INTEX Motorola SM56 PCI Speakerphone Modem

074134.75 0 init vgmulti ver 5.2.3018

074134.80 0 Inband Signaling Config file not specified

074134.80 0 Loading VMB data begin

074134.86 0 Loading VMB data - about to delete old entries

074134.86 0 Loading VMB data - sorting/ordering

074134.86 0 Loading VMB data end

074135.46 0 init clear settings on 1 devices.

074135.46 0 Initialising...

074135.52 0 init attach vgs on 1 devices.

074135.52 0 Script Load E:\SOFTWARE\VoiceGuide\KuanYinScripts\AmitabhaNew.vgs

074135.90 0 init lineopen on 1 devices.

074135.90 0 Calling .lineOpen on device 1

074136.56 0 lineOpen(0)=>

074136.56 0 Calling .GetLineHandle on LineId 0

074136.56 0 hLine=4328560

074136.56 0 Calling .GetProviderInfo on LineId 0

074136.56 0 tapi ProviderInfo: Windows Telephony Service Provider for Universal Modem Driver

074136.56 0 set provider type: PROVTYPE_MODEM

074136.56 0 Calling lineSetNumRings on lLineHandle 4328560

074136.56 0 Waiting for a call...

074156.61 0 callstate OFFERING 4328960 0 4

074156.61 0 ring 1

074156.61 0 Answer the call at 11/7/04 7:41:56 AM

074156.61 0 lineAnswer(4328960) => 1

074156.61 0 tapi Reply (LineEvReply) ok 1 0

074156.61 0 callstate ACCEPTED 4328960 0 0

074157.82 0 callstate CONNECTED 4328960 0 0

074157.82 0 callstate CONNECTED 4328960,0,0

074157.82 0 WorkingModeTAPI@Connected=

074157.82 0 WorkingModeScript@Connected=

074157.82 0 Inband detection not enabled

074157.82 0 StartLoadedVgs at 11/7/04 7:41:57 AM

074157.82 0 AddRVns [scriptsPath]{E:\SOFTWARE\VoiceGuide\KuanYinScripts\}

074157.82 0 AddRVns [scriptPath]{E:\SOFTWARE\VoiceGuide\KuanYinScripts}

074157.82 0 rv add [$RV_STARTTIME]{11/7/04 7:41:57 AM}

074157.82 0 rv add [$RV_DEVICEID]{0}

074157.82 0 rv add [$RV_CIDNAME]{}

074157.82 0 AddRVns [PathApp]{D:\PROGRAM FILES\VOICEGUIDE\}

074157.87 0 rv add [$RV_CIDNUMBER]{}

074157.87 0 timer clear

074157.87 0 [Welcome] Number Input

074157.87 0 [Welcome] Playing (D:\Program Files\VoiceGuide\AmitabhaSoundFiles\SeekDonateUpdate.wav)

074157.87 0 play set playid=708902

074158.20 0 PlaySoundStart ok [D:\Program Files\VoiceGuide\AmitabhaSoundFiles\SeekDonateUpdate.wav]

074158.20 0 timer clear

074158.20 0 wa(17789,70890200)

074206.66 0 dtmf 1 (4328960,49,2)

074206.66 0 ScriptEventCode 49 iLineState=1300

074206.66 0 LsGetNbrsPlayWelcMsg 1

074207.37 0 PlaySoundStop err=0

074207.37 0 [Welcome] Number Input 1

074207.37 0 rv add [Welcome]{1}

074207.43 0 timer clear

074207.43 0 [seeker] Number Input

074207.43 0 [seeker] Playing (D:\Program Files\VoiceGuide\AmitabhaSoundFiles\bloodgroup.wav)

074207.43 0 play set playid=718456

074207.65 0 PlaySoundStart ok [D:\Program Files\VoiceGuide\AmitabhaSoundFiles\bloodgroup.wav]

074207.65 0 timer clear

074207.65 0 wa(14280,71845600)

074210.01 0 dtmf 4 (4328960,52,2)

074210.01 0 ScriptEventCode 52 iLineState=1300

074210.01 0 LsGetNbrsPlayWelcMsg 4

074210.56 0 PlaySoundStop err=0

074210.56 0 [seeker] Number Input 4

074210.56 0 rv add [seeker]{4}

074210.61 0 timer clear

074210.61 0 [positiveORnegative] Number Input

074210.61 0 [positiveORnegative] Playing (D:\Program Files\VoiceGuide\AmitabhaSoundFiles\positiveornegative.wav)

074210.61 0 play set playid=721655

074210.78 0 PlaySoundStart ok [D:\Program Files\VoiceGuide\AmitabhaSoundFiles\positiveornegative.wav]

074210.83 0 timer clear

074210.83 0 wa(9018,72165500)

074213.41 0 dtmf 1 (4328960,49,2)

074213.41 0 ScriptEventCode 49 iLineState=1300

074213.41 0 LsGetNbrsPlayWelcMsg 1

074213.96 0 PlaySoundStop err=0

074213.96 0 [positiveORnegative] Number Input 1

074213.96 0 rv add [positiveORnegative]{1}

074214.02 0 timer clear

074214.02 0 [searchPhones] DB Query

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

074214.07 0 rv replace start: [sELECT Phone FROM nameNphone WHERE [Group= $Rv[seeker] AND PositiveORnegative= $Rv[positiveORnegative]]]

074214.13 0 rv ns [PathSysVoice]{}[PathApp]{D:\PROGRAM FILES\VOICEGUIDE\}[PathDataVm]{D:\PROGRAM FILES\VOICEGUIDE\data\}[PathVgSys]{D:\PROGRAM FILES\VOICEGUIDE\system\}[scriptsPath]{E:\SOFTWARE\VoiceGuide\KuanYinScripts\}[scriptPath]{E:\SOFTWARE\VoiceGuide\KuanYinScripts}[$RV_STARTTIME]{11/7/04 7:41:57 AM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{D:\PROGRAM FILES\VOICEGUIDE\}[$RV_CIDNUMBER]{}[Welcome]{1}[seeker]{4}[positiveORnegative]{1}

074214.13 0 rv replace end: [sELECT Phone FROM nameNphone WHERE [Group= 4 AND PositiveORnegative= 1]]

074214.13 0 db About to execute a Retrieve type operation [sELECT Phone FROM nameNphone WHERE [Group= 4 AND PositiveORnegative= 1]]

074214.13 0 OpenRecordset: 3061:Too few parameters. Expected 1.

074214.13 0 path {0} not found

074214.13 0 path {} not found

074214.13 0 timer clear

074214.13 0 [Error] Playing

074214.18 0 tts generate start[Jaibhom with great love from all of us here in the Pure Land of Buddha Amitabha. may everyone delight into the pure land of their pure mind.]

074214.18 0 tts generate wait

074214.18 0 RunModule PLAY end

074218.63 0 callstate DISCONNECTED 4328960 1 0

074218.63 0 ScriptEventCode 9250 iLineState=1100

074218.63 0 LsPlayMsg EV_REMOTEPARTY_DISCONNECT

074218.69 0 rv add [Hangup Time]{11/7/04 7:42:18 AM}

074218.69 0 Hanging up call...

074218.69 0 RecSoundStop ok

074218.69 0 PlaySoundStop err=0

074218.69 0 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

074218.69 0 fnHangupCall end

074218.91 0 callstate IDLE 4328960 0 0

074218.96 0 WorkingMode@Idle=

074218.96 0 timer clear

074218.96 0 timer set 1 EV_TIMEOUT_TIMETOREINITLINE

074218.96 0 tapi Reply (LineEvReply) ok 2 0

074220.01 0 timer fired EV_TIMEOUT_TIMETOREINITLINE

074220.01 0 ScriptEventCode 9008 iLineState=900

074220.01 0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

074220.01 0 ReinitTelephony due to IDLE

074220.01 0 tapic lineDeallocateCall(MainCall:4328960) 0

074223.47 0 lineOpen(0)=>

074223.47 0 Waiting for a call...

074223.47 0 LineHandle=4328640

074223.47 0 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT

074224.07 0 dial start any summary:|0:rdy=0|

074225.11 0 dial start any summary:|0:rdy=0|

074226.16 0 dial start any summary:|0:rdy=0|

074226.82 0 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT

074226.82 0 ScriptEventCode 9013 iLineState=900

074229.45 0 btn Exit (1 lines)

074229.45 0 line state =900

074229.45 0 Exiting...

074229.62 0 calling TapiWrap.Shutdown

074231.81 0 Unloading Main Window

[SupportTeam]

I suspect that the problem is because you are using square brackets in your SQL statement:

SELECT Phone FROM nameNphone WHERE [Group= 4 AND PositiveORnegative= 1]

You should probably be using 'round brackets'...

[Guest researcher]

Oh. Thanks. Your support is wonderfull. In a SQL statement not [ ] but ( ) brackets worked.Thanks.