Pass special character string to Orient DB funcation

[Abhijit Shivathare]

We are using the node.js to connect the Orient DB using orientjs node package.

when we pass the value with special character string to Orient DB function (JavaScript function) ,  it gives error when we create vertex. 

Please suggest the solution for same.  

[alessand...@gmail.com]

Hi,

do you have a test case to reproduce the problem?

Thanks,

Alessandro

[Abhijit Shivathare]

 value to pass function

 desc: 'WhatsApp funny Videos 2016\nTry not to grin or Laugh Hardest\n',
 id = 1000

 function

var db = orient.getGraph();
var vkQuery = "CREATE VERTEX post CONTENT {'id':'"+ id+"', 'desc':'"+ desc +"'}";
var vkInsert = db.command("sql",vkQuery);

error : 

    addpost: 'error com.orientechnologies.orient.core.sql.parser.TokenMgrError: Lexical error at line 1, column 637.  Encountered: "\\n" (10), after : "\\\'WhatsApp funny Videos 2016"',

[alessand...@gmail.com]

Hi,

could you try with

desc = 'WhatsApp funny Videos 2016\\nTry not to grin or Laugh Hardest\\n';

var vkQuery = "CREATE VERTEX post CONTENT {'id':"+ id+", 'desc':'"+ desc +"'}";

Best regards,

Alessandro

[Abhijit Shivathare]

How to change the run time value to 'desc', does any encoder for value?

desc = 'WhatsApp funny Videos 2016\\nTry not to grin or Laugh Hardest\\n';

var vkQuery = "CREATE VERTEX post CONTENT {'id':"+ id+", 'desc':'"+ desc +"'}";




[alessand...@gmail.com]

I'm sorry, I don't understand what you mean, could you explain better?

Alessandro

[alessand...@gmail.com]

Hi,

did you mean update the records ?

If yes, you could use 

update Post set `desc`="yourDesc" where id=1000

beacuse desc is a reserved word and you must use `desc`

Thanks,

Alessandro

[Abhijit Shivathare]

I need to update input string special characters ,( e.g / to // ) when it use in query.

[alessand...@gmail.com]

Hi,

could you post an example of your query to update input string special characters ?

Thanks

[Abhijit Shivathare]

I have one function 'addpost' with language  'JavaScript' & Input parameters for the function are id and desc. 'desc' parameter value  may be contain the spacial characters. like ('WhatsApp funny Videos 2016\nTry not to grin or Laugh Hardest\n')

var db = orient.getGraph();


var vkQuery = "CREATE VERTEX post CONTENT {'id':'"+ id+"', 'desc':'"+ desc +"'}"; 


var vkInsert = db.command("sql",vkQuery);

It cause for error  :     addpost: 'error com.orientechnologies.orient.core.sql.parser.TokenMgrError: Lexical error at line 1, column 637.  Encountered: "\\n" (10), after : "\\\'WhatsApp funny Videos 2016"',

Is there is any way resolve this issue.

[alessand...@gmail.com]

Hi,

I tried it and I did not have errors

[Abhijit Shivathare]

try with this value 
desc = ' Bollywood Superstar Akshay Kumar, Ileana D'Cruz'

you may get the error

[alessand...@gmail.com]

Hi,

you could use

var db = orient.getGraph();
var id= 1000;
var desc = "Bollywood Superstar Akshay Kumar, Ileana D'Cruz"

var vkQuery = 'CREATE VERTEX post CONTENT {"id":'+ id+',"desc":"'+ desc +'"}';
var vkInsert = db.command("sql",vkQuery);

Best regards,

Alessandro

[prasad....@anzu.org]

Hello, I have similar issue  where the desc field is a text box where user can add any text. I run into issues where the function breaks when there are special characters in desc like single or double quot's , / \ # ! $ % etc.

is there a way or inbuilt function that will take care or these special chars ?  you can use same function code to reproduce the issue with desc with different special characters .     

[Suyog Kale]

hi Alessandro,

What if source string contains both single and double quotes.

var db = orient.getGraph();
var id= 1000;
var desc = "Bollywood Superstar "Akshay Kumar", Ileana D'Cruz"

var vkQuery = 'CREATE VERTEX post CONTENT {"id":'+ id+',"desc":"'+ desc +'"}';
var vkInsert = db.command("sql",vkQuery);

[alessand...@gmail.com]

Hi,

you could use 

var db = orient.getGraph();
var id= 1000;

var mydesc = "Bollywood Superstar \"Akshay Kumar\", Ileana D'Cruz";
var desc=JSON.stringify(mydesc);

var vkQuery = 'CREATE VERTEX post CONTENT {"id":'+ id+',"desc":'+ desc +'}';
var vkInsert = db.command("sql",vkQuery);

Hope it helps.

Best regards,

Alessandro