Database Query

[health4us]

I have input data into voiceguide and am now trying to query my database for this data.. the data i am querying is a 4 digit number... the number i input is right but voiceguide gives me an error message.. What does this message mean and how do i fix it please? thanks Matt

 

110900.59 7 callstate CONNECTED 66479,1,0

110900.59 7 WorkingModeTAPI@Connected=

110900.59 7 WorkingModeScript@Connected=

110900.62 0 dial callque delete id=7

110900.63 7 Live person answered, starting C:\Program Files\VoiceGuide\Scripts\recruitment\IncomingCalls\IncomingCall.vgs

110900.63 2 tr NewVgsVgm_Goto C:\Program Files\VoiceGuide\Scripts\recruitment\IncomingCalls\IncomingCall.vgs,,,,,0

110900.63 0 LoadedVgs_Find C:\Program Files\VoiceGuide\Scripts\recruitment\IncomingCalls\IncomingCall.vgs at idx=3

110900.63 7 cl NewVgsVgm_RunModule module not found:

110900.63 2 tr NewVgsVgm_Goto 1

110900.63 2 tr NewVgsVgm_Goto 2

110900.63 7 [QUERY CALLER ID] DB Query

110900.63 7 Jet mode used (To use ODBC mode specify ODBC Connect string)

110900.64 7 RVreplace start (strlen>100)

110900.64 7 About to execute Retrieve Operation [sELECT Title, Name, Surname, UKPhoneNumber, CallersName, CallStatus, LeadSource, CallSubject, Address1, Address2, Address3, City, County, Postcode, CallersEmail, CampaignName, CallersText, TrainingComputerId, AccessCode FROM NamesList WHERE PhoneNumber=01423325554]

110900.64 7 [QUERY CALLER ID] movelast err : No current record.

110900.64 7 [F.Enter Pin Code] Number Input

110900.64 7 [F.Enter Pin Code] Playing (enter-access-code.wav)

110900.68 7 PlaySoundStart ok [enter-access-code.wav]

110900.68 2 tr NewVgsVgm_Goto end

110902.98 7 wb(90033600)

110903.98 7 Play End line[7] (id=900336)

110903.98 7 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED

110905.69 7 dtmf 0 (66479,48,2)

110905.69 7 LsGetNbrsRxDigits 0

110905.70 7 [F.Enter Pin Code] Number Input 0

110906.63 7 dtmf 0 (66479,48,2)

110906.63 7 LsGetNbrsRxDigits 0

110906.63 7 [F.Enter Pin Code] Number Input 00

110907.07 7 dtmf 5 (66479,53,2)

110907.07 7 LsGetNbrsRxDigits 5

110907.07 7 [F.Enter Pin Code] Number Input 005

110907.55 7 dtmf 1 (66479,49,2)

110907.55 7 LsGetNbrsRxDigits 1

110907.55 7 [F.Enter Pin Code] Number Input 0051

110913.50 7 LsGetNbrsRxDigits EV_TIMEOUT_ENTERDATA

110913.50 7 fn PlaySoundStartNumbers record-number-youhaveenteredthefollowingnumber.wav, record-number-press1ifcorrect.wav, 0051, Digits

110913.50 7 twcal PlaySayNumber record-number-youhaveenteredthefollowingnumber.wav, record-number-press1ifcorrect.wav, 0051, , 1

110913.54 7 PlaySoundStartNumbers ok

110915.35 7 dtmf 1 (66479,49,2)

110915.35 7 LsGetNbrsPlayConfirm 1

110916.35 7 PlaySoundStop ok

110916.35 7 path {0051} not found

110916.36 7 dtmf 1 (66479,49,2)

110916.37 7 [s/F.Search Pin Code] DB Query

110916.37 7 Jet mode used (To use ODBC mode specify ODBC Connect string)

110916.38 7 RVreplace start (strlen>100)

110916.38 7 About to execute Retrieve Operation [sELECT Title, Name, Surname, UKPhoneNumber, CallersName, CallStatus, LeadSource, CallSubject, Address1, Address2, Address3, City, County, Postcode, CallersEmail, CampaignName, CallersText, TrainingComputerId FROM NamesList WHERE AccessCode=0051]

 

HERE IS THE ERROR

110916.38 7 ERROR 5.1.2055 OpenRecordset: 3464:Data type mismatch in criteria expression.

110916.38 7 [F. Get a Pin Code] Playing

110916.39 7 tts generate start[wrong access code.. press 1 to try again]

110916.48 7 tts generate end

110916.49 7 [F. Get a Pin Code] Playing (C:\Program Files\VoiceGuide\system\tts7.wav)

110916.50 7 PlaySoundStart ok [C:\Program Files\VoiceGuide\system\tts7.wav]

110916.50 7 RunModule PLAY end

110920.70 7 wb(91617900)

110921.71 7 Play End line[7] (id=916179)

110921.71 7 LsPlayMsg EV_PLAY_FINISHED

110931.62 7 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

110931.62 7 Hanging up call... [Hangup Module]

110931.62 7 RecSoundStop ok

110931.62 7 PlaySoundStop ok

110931.62 7 fnHangupCall end

110931.66 7 linedevstate 2048 0 0

110931.67 7 callstate IDLE 66479 0 0

110931.67 7 WorkingMode@Idle=

110931.69 7 tapi Reply (LineEvReply) ok 66497 0

110932.62 7 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

110932.62 7 ReinitTelephony due to IDLE start

110932.62 7 tapic lineDeallocateCall(MainCall:66479) 0

110932.77 7 lineOpen(7) => 0

110932.77 7 Waiting for a call...

110932.77 7 lineOpen(7)LineHandle=65557

[health4us]

Is it possible to update 2 database records/tables in the same access database using only 1 database module? If so do i just repeat this code twice and change the relevant table names etc?

 

UPDATE NamesList SET CallStatus='LISTENING TO RECORDED CALL 1', LastUpdated='$RV_STARTTIME' WHERE AccessCode='$RV[GetClientRecord_19_1]'

 

 

Thanks

Matt

[health4us]

Sorry i asked 2 questions at once on 2 messages in error... please can you take the time to answer both... thanks Matt

[SupportTeam]

"Data type mismatch in criteria expression" error

The error description pretty much says it all... The error is generated by MS Access - there should be more info on this error in MS Access Help file, or you may search for "Data type mismatch in criteria expression" on http://www.google.com.au/advanced_group_search?hl=en

Is it possible to update 2 database records/tables in the same access database using only 1 database module?

VoiceGuide just passes the contents of the SQL statement to the database, so it all depends on whether the database accepts such a statement or not... best to consult the databases Help file on this one as well.