This works.
var db = orient.getGraph();
var pt = db.command("sql","select * from ZTitleID where pat_id = ?", [id]);
var res = pt[0].getRecord();
return res.field('DT');
Might help someone.
Thanks
On Tuesday, February 11, 2014 9:58:21 AM UTC+5:30, Shishya wrote:
>
> Hi Luca,
>
> yet again, now select on other fields are not working. I am sure, I am
> missing something silly
>
> var pt = db.command("sql","select @rid,DT from ZTitleID where pat_id = ?"
> , [id]);
> return pt[0].rid + pt[0].DT + pt[0].getIdentity();//Error on all 3
>
> How to get fields and identity in a single query. Or do i need separate
> queries for each?
>
> Regards
>
>
> On Monday, February 10, 2014 6:43:36 PM UTC+5:30, Shishya wrote:
>>
>> Wallah ! works.
>>
>> Thanks a lot!
>>
>> On Monday, February 10, 2014 6:16:28 PM UTC+5:30, Lvc@ wrote:
>>>
>>> Try:
>>>
>>> res[0].getIdentity()
>>>
>>>
>>> On 10 February 2014 13:40, Shishya <[email protected]> wrote:
>>>
>>>> res[0] gives v(ZTitleID)[#11:0]
>>>>
>>>> Am I doing the correct array browsing. I see there is only 1 element in
>>>> that object.
>>>>
>>>> Regards
>>>>
>>>>
>>>> On Monday, February 10, 2014 5:54:15 PM UTC+5:30, Lvc@ wrote:
>>>>
>>>>> res is an array of vertices (ZTitleID extends V), so you should browse
>>>>> res array and get single entry's identity.
>>>>>
>>>>> Lvc@
>>>>>
>>>>>
>>>>>
>>>>> On 10 February 2014 13:18, Shishya <[email protected]> wrote:
>>>>>
>>>>>> Code
>>>>>> var db = orient.getGraph();
>>>>>> var res = db.command("sql","select * from ZTitleID where pat_id = ?",
>>>>>> ['06615119']);
>>>>>> //res
>>>>>>
>>>>>> I expect res to contain rid but contains vZTitleID[#11:0]
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>>
>>>>>> On Monday, February 10, 2014 4:57:52 PM UTC+5:30, Lvc@ wrote:
>>>>>>
>>>>>>> That is an array, so you should get the RID on each element of the
>>>>>>> array.
>>>>>>>
>>>>>>> What API have you used to do the query? Please could you post the
>>>>>>> code of that function?
>>>>>>>
>>>>>>> Lvc@
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 10 February 2014 12:23, Shishya <[email protected]> wrote:
>>>>>>>
>>>>>>>> I get the following error
>>>>>>>>
>>>>>>>>
>>>>>>>> sun.org.mozilla.javascript.internal.EvaluatorException: Java class
>>>>>>>> "[Ljava.lang.Object;" has no public instance field or method named
>>>>>>>> "getIdentity". (<Unknown source>#65) in <Unknown source> at line
>>>>>>>> number 65
>>>>>>>> Java class "[Ljava.lang.Object;" has no public instance field or
>>>>>>>> method named "getIdentity". (<Unknown source>#65)
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Monday, February 10, 2014 4:32:54 PM UTC+5:30, Lvc@ wrote:
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>> if you're working with graph API get it as:
>>>>>>>>>
>>>>>>>>> .getIdentity()
>>>>>>>>>
>>>>>>>>> Lvc@
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 10 February 2014 11:46, Shishya <[email protected]> wrote:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> I have been struggling with getting RID from select/create
>>>>>>>>>> through javascript functions return in select or create. What I get
>>>>>>>>>> is this
>>>>>>>>>> format, v(ZTitleID)[#11:0]
>>>>>>>>>>
>>>>>>>>>> Any idea for how to get rid like #11:0 from this?
>>>>>>>>>>
>>>>>>>>>> Please help
>>>>>>>>>>
>>>>>>>>>> Regards
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>>
>>>>>>>>>> ---
>>>>>>>>>> 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.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>
>>>>>>>> ---
>>>>>>>> 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.
>>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>
>>>>>> ---
>>>>>> 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.
>>>>>>
>>>>>
>>>>> --
>>>>
>>>> ---
>>>> 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.
>>>>
>>>
>>>
--
---
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.
