Issue #4837 opened I suppose I could encode my updates to the Java API instead of assembling SQL but I think it would be useful to be able to update this data through SQL as well as direct API.
Thanks On Friday, 21 August 2015 06:46:10 UTC-6, l.garulli wrote: > > Hi Glenn, > Please could you open a new issue or that? > > Best Regards, > > Luca Garulli > Founder & CEO > OrientDB <http://orientdb.com/> > > > On 21 August 2015 at 13:15, Glenn Irwin <[email protected] > <javascript:>> wrote: > >> I am migrating to 2.1 and I noticed that the SQL parser gives me an error >> when I try to give it a data string (wrapped in quotes) with a newline or >> \r in it. I am just trying to update the field that was inserted directly >> with Java API which accepted the data just fine with the newlines. But >> when I update it using SQL, it doesn't accept it. >> >> Exception in thread "Thread-8" >> com.orientechnologies.orient.core.sql.parser.TokenMgrError: Lexical error >> at line 1, column 68. Encountered: "\r" (13), after : "\"/* horizontal >> menu style */" >> >> at >> com.orientechnologies.orient.core.sql.parser.OrientSqlTokenManager.getNextToken( >> OrientSqlTokenManager.java:3370) >> >> at com.orientechnologies.orient.core.sql.parser.OrientSql.getToken( >> OrientSql.java:12758) >> >> at com.orientechnologies.orient.core.sql.parser.OrientSql.Expression( >> OrientSql.java:4167) >> >> at com.orientechnologies.orient.core.sql.parser.OrientSql.UpdateItem( >> OrientSql.java:2403) >> >> at >> com.orientechnologies.orient.core.sql.parser.OrientSql.UpdateOperations( >> OrientSql.java:2220) >> >> at com.orientechnologies.orient.core.sql.parser.OrientSql.UpdateStatement( >> OrientSql.java:2053) >> >> at com.orientechnologies.orient.core.sql.parser.OrientSql.Statement( >> OrientSql.java:571) >> >> at com.orientechnologies.orient.core.sql.parser.OrientSql.parse( >> OrientSql.java:79) >> >> >> any advice as to what I can do? Is there any way to encode a newline in >> a string in OrientDB SQL? >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
