Good Afternoon Everyone, I am using torque 3.1 and experiencing a strange problem with escape character in dir path. Environment: jdk1.4 torque 3.1 MSSQlServer 2000 OS: windows 2000 server
In database table, i have a column to store filePath. I read a file path from file which is "SINGLE \" C:\dev\test\myfile.doc and since java adds a escape"\" character so in debugging i see this path as " DOUBLE \\" C:\\dev\\test\\myfile.doc but while saving in DB torque saves this correctly,as expected "SINGLE \" C:\\dev\\test\\myfile.doc. When i try to retrieve this data using torque criteria the filePath set as "SINGLE \" C:\dev\test\myfile.doc and as discussed earlier java adds escape character torque criteria has filePath value " DOUBLE \\" C:\\dev\\test\\myfile.doc. Now i never get the saved row back, since db value "SINGLE \" C:\dev\test\myfile.doc will never match with DOUBLE \\" C:\\dev\\test\\myfile.doc and hence no row is returned back. The above mentioned example works fine with path as C:/dev/test/myfile.doc ie saving and retrieval works. Please suggest how can i fix this problem, and make torque save and retrieve same value. thanks Sandeep Chhikara
