Directory Path Problem

[kiran.mply]

Hi

 

I am using the following script to insert into MYSQL database with the help of Query Database module

 

INSERT INTO CONTACTDB.CASES (CALL_TIME,CALLER_ID,CASE_PATH) VALUES('$RV_STARTTIME','$RV_CIDNUMBER','$RV[LmRecDirectory]')

The data is getting inserted. But here I am using a variable $RV[LmRecDirectory]

This varible contains a directory path

 

113606.796 22 7 comlg CPS Data: DataPath: 9989505111_1031113606

113606.796 22 7 comlg CPS Data: Directory Path: C:\Chatline\scripts\CpsData\9989505111_1031113606

113606.812 22 7 rem Run_ResultReturn [[LmRecDirectory]{C:\Chatline\scripts\CpsData\9989505111_1031113606}]

113606.812 22 7 rvns add [LmRecDirectory]{C:\Chatline\scripts\CpsData\9989505111_1031113606}

113606.812 22 7 FindNextVgmTitleInPathList: next module title is=[LmSetSilenceDetectLen]

 

But what is happening here is this data is getting inserted as C:ChatlinescriptsCpsData9989505111_1031104844

The " \ " character is getting escaped and inserted into the databse.

 

I have searched the forum but couldn't find any post related to such problem

[kiran.mply]

Hi

 

The problem is solved its the problem with database

If we insert C:\\Chatline\\scripts\\CpsData\\9989505111_1031113606 i,e use a double slash its working.