Hi, That is because it is always collection ). Try this one UPDATE atable SET value = $a[0] WHERE field='AA' let a = (select name from #13:0)
On Sun, Feb 2, 2014 at 1:44 AM, Glenn Irwin <[email protected]> wrote: > When doing an update like: > > UPDATE atable SET value = (select name from #13:0) WHERE field='AA' > > I end up with returned data from the select enclosed in square brackets. > like this: [thename] > in other words, whatever gets retrieved by the select has these [] > brackets wrapped around it. > > How do I get rid of those? > > I have tried everything I can think of but I cannot lose them. I want to > update with the value 'thename' not '[thename]' > > Using 1.6.0-SNAPSHOT > > Glenn. > > -- > > --- > 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/groups/opt_out. > -- Best regards, Andrey Lomakin. Orient Technologies the Company behind OrientDB -- --- 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/groups/opt_out.
