Database Problem

[Guest rajinder]

Trying to do database query but failed. Please tell the solution.

 

125808.80 8 linedevstate 2048 0 0

125808.80 8 callstate OFFERING 66186 0 4

125808.80 8 Answer the call at 6/8/2005 12:58:08 PM

125808.80 8 lineAnswer(66186) => 66135

125808.80 8 callinfo CALLEDID

125808.80 8 callinfo ORIGIN

125808.80 8 ring 0

125809.34 8 callstate CONNECTED 66186 1 0

125809.34 8 callstate CONNECTED 66186,1,0

125809.34 8 WorkingModeTAPI@Connected=

125809.34 8 WorkingModeScript@Connected=

125809.36 8 Inband detection not enabled

125809.36 8 StartLoadedVgs at 6/8/2005 12:58:09 PM

125809.36 8 AddRVns [scriptsPath]{E:\Call center\}

125809.36 8 AddRVns [scriptPath]{E:\Call center}

125809.36 8 rv add [$RV_STARTTIME]{6/8/2005 12:58:09 PM}

125809.36 8 rv add [$RV_DEVICEID]{8}

125809.36 8 rv add [$RV_CIDNAME]{}

125809.36 8 AddRVns [PathApp]{D:\Program Files\VoiceGuide\}

125809.36 8 rv add [$RV_CIDNUMBER]{}

125809.36 8 tapi Reply (LineEvReply) ok 66135 0

125809.36 8 TimeoutClear

125809.36 8 [Welcome] Playing

125809.36 8 [Welcome] Playing (Welcome note.wav)

125809.36 8 play set playid=852015

125809.38 8 PlaySoundStart ok [E:\Call center\Welcome note.wav]

125809.38 8 TimeoutClear

125809.38 8 RunModule PLAY end

125809.38 8 wa(4823,85201500)

125809.38 8 callinfo MONITORMODES

125809.38 8 callinfo MONITORMODES

125813.13 8 dtmf 1 (66186,49,2)

125813.13 8 ScriptEventCode 49 iLineState=1100

125813.13 8 LsPlayMsg 1

125813.17 8 PlaySoundStop err=0

125813.17 8 rv add [Welcome]{1}

125813.17 8 TimeoutClear

125813.17 8 [Get IDN] Number Input

125813.17 8 [Get IDN] Playing (IDN Entering.wav)

125813.17 8 play set playid=855828

125813.17 8 PlaySoundStart ok [E:\Call center\IDN Entering.wav]

125813.17 8 TimeoutClear

125813.19 8 wa(5847,85582800)

125813.19 8 callinfo MONITORMODES

125818.80 8 dtmf 1 (66186,49,2)

125818.80 8 ScriptEventCode 49 iLineState=1300

125818.80 8 LsGetNbrsPlayWelcMsg 1

125818.84 8 PlaySoundStop err=0

125818.84 8 [Get IDN] Number Input 1

125818.84 8 path {1} not found

125818.84 8 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

125819.63 8 dtmf 2 (66186,50,2)

125819.63 8 ScriptEventCode 50 iLineState=1301

125819.63 8 LsGetNbrsRxDigits 2

125819.63 8 [Get IDN] Number Input 12

125819.63 8 path {12} not found

125819.63 8 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

125820.58 8 dtmf 0 (66186,48,2)

125820.58 8 ScriptEventCode 48 iLineState=1301

125820.58 8 LsGetNbrsRxDigits 0

125820.58 8 [Get IDN] Number Input 120

125820.58 8 path {120} not found

125820.58 8 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

125821.34 8 dtmf 2 (66186,50,2)

125821.36 8 ScriptEventCode 50 iLineState=1301

125821.36 8 LsGetNbrsRxDigits 2

125821.36 8 [Get IDN] Number Input 1202

125821.36 8 path {1202} not found

125821.36 8 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

125822.20 8 dtmf 4 (66186,52,2)

125822.20 8 ScriptEventCode 52 iLineState=1301

125822.20 8 LsGetNbrsRxDigits 4

125822.20 8 [Get IDN] Number Input 12024

125822.20 8 path {12024} not found

125822.20 8 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

125823.03 8 dtmf 2 (66186,50,2)

125823.03 8 ScriptEventCode 50 iLineState=1301

125823.03 8 LsGetNbrsRxDigits 2

125823.03 8 [Get IDN] Number Input 120242

125823.03 8 path {120242} not found

125823.03 8 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

125823.78 8 dtmf 2 (66186,50,2)

125823.78 8 ScriptEventCode 50 iLineState=1301

125823.78 8 LsGetNbrsRxDigits 2

125823.78 8 [Get IDN] Number Input 1202422

125823.78 8 path {1202422} not found

125823.78 8 TimeoutSet 6 EV_TIMEOUT_ENTERDATA

125823.78 8 TimeoutClear

125823.78 8 rv add [Get IDN]{1202422}

125823.78 8 path {1202422} not found

125823.78 8 AddRVns [Get IDN_PathTaken]{success}

125823.78 8 TimeoutClear

125823.78 8 [Check IDN] DB Query

125823.78 8 db Jet mode used (To use ODBC mode specify ODBC Connect string)

125823.80 8 rv replace start: [sELECT cs FROM idn WHERE idn = '$RV[Get IDN]']

125823.80 8 rv ns [PathSysVoice]{}[PathApp]{D:\Program Files\VoiceGuide\}[PathDataVm]{D:\Program Files\VoiceGuide\data\}[PathVgSys]{D:\Program Files\VoiceGuide\system\}[scriptsPath]{E:\Call center\}[scriptPath]{E:\Call center}[$RV_STARTTIME]{6/8/2005 12:58:09 PM}[$RV_DEVICEID]{8}[$RV_CIDNAME]{}[PathApp]{D:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[Welcome]{1}[Get IDN]{1202422}[Get IDN_PathTaken]{success}

125823.81 8 rv replace end: [sELECT cs FROM idn WHERE idn = '1202422']

125823.81 8 db About to execute a Retrieve type operation [sELECT cs FROM idn WHERE idn = '1202422']

125823.84 8 OpenRecordset: 3061:Too few parameters. Expected 2.

125823.84 8 TimeoutClear

125823.84 8 [invalid IDN] Playing

125823.84 8 [invalid IDN] Playing (Invalid IDN.wav)

125823.86 8 play set playid=866515

125823.88 8 PlaySoundStart ok [E:\Call center\Invalid IDN.wav]

125823.89 8 TimeoutClear

125823.91 8 RunModule PLAY end

125823.91 8 wa(2635,86651500)

125823.92 8 callinfo MONITORMODES

125826.58 8 play end current play (playid=866515)

125826.58 8 ScriptEventCode 8001 iLineState=1100

125826.58 8 LsPlayMsg EV_PLAY_FINISHED

125826.58 8 TimeoutSet 10 EV_TIMEOUT_HANGUP

125826.58 8 TimeoutSet 10 EV_TIMEOUT_HANGUP

125837.48 8 Timer fired EV_TIMEOUT_HANGUP

125837.48 8 ScriptEventCode 9001 iLineState=1101

125837.48 8 LsPlayMsgFinished EV_TIMEOUT_HANGUP

125837.48 8 rv add [Hangup Time]{6/8/2005 12:58:37 PM}

125837.48 8 Hanging up call...

125837.48 8 RecSoundStop ok

125837.48 8 PlaySoundStop err=0

125837.48 8 TimeoutSet 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

125837.48 8 fnHangupCall end

125837.53 8 linedevstate 2048 0 0

125837.53 8 callstate IDLE 66186 0 0

125837.53 8 WorkingMode@Idle=

125837.53 8 TimeoutClear

125837.53 8 TimeoutSet 1 EV_TIMEOUT_TIMETOREINITLINE

125837.53 8 tapi Reply (LineEvReply) ok 66152 0

125838.58 8 Timer fired EV_TIMEOUT_TIMETOREINITLINE

125838.58 8 ScriptEventCode 9008 iLineState=900

125838.58 8 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

125838.58 8 ReinitTelephony due to IDLE

125838.58 8 tapic lineDeallocateCall(MainCall:66186) 0

125838.63 8 lineOpen(8)=>

125838.63 8 Waiting for a call...

125838.63 8 LineHandle=66033

125838.63 8 TimeoutSet 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT

125838.94 0 dial start any summary:|8:rdy=0|

125839.94 0 dial start any summary:|8:rdy=0|

125840.94 0 dial start any summary:|8:rdy=0|

125841.92 8 Timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT

125841.92 8 ScriptEventCode 9013 iLineState=900

125851.70 0 sys cleanup Start

125851.70 0 sys cleanup End

 

Attaching the database file also, I want to select "c s" from idn table where "idn" = received dtmf tone

Database.zip

[SupportTeam]

The column in database is "i d n", not "idn" - so the SQL command is wrong.

 

Rename "i d n" to something else - with no spaces. eg. if you were to name that column "idnumber" then the SQL would be:

 

SELECT cs FROM idn WHERE idnumber= '1202422'